CODEWITHSUNDEEP
mysqloracle-databasesymmetricds
user6105689
user6105689

Reputation:

Symmetricds: is possible transform data during the migration or syncronization?

I need to migrate and sync data from an oracle to mysql. Plus I want, during the sync and migration, a data transformation because mysql has a differente table design from oracle.

I'm trying to use symmetricds for my goal, but if I understand well, symmetric can do the sync or migration, and after that you can do some transformation on table, but this operation is not automatic, you must do it by hand. Isn'it?

If I'm wrong tell me how can achive my goal with symmetricds, or if is not possible, suggest some tool for my needed.

Thanks a lot, have a nice day

Upvotes: 0

Views: 153

Answers (1)

Josh
Josh

Reputation: 377

SymmetricDS transforms (extract and/or load) will fire as part of replication from source to target. So you can use them when the databases do not match on the source and target. It will be automatic as part of the normal synchronization process.

Upvotes: 0

Related Questions