CODEWITHSUNDEEP
mysqldatabasepostgresqlsynchronizationsymmetricds
Caballero
Caballero

Reputation: 12101

SymmetricDS: real time synchronisation of MySQL with PostgreSQL

I need to move a huge system from MySQL to PostgreSQL. This cannot be done in one go, which is why I need a robust (real time or near real time) data bi-directional synchronisation solution between MySQL and PostgreSQL. SymmetricDS looks like a tool that could solve my problem. However...

Would SymmetricDS be capable of this? The documentation is extensive and it doesn't clearly state that it would work in this particular situation. I'd like to know that this is at least possible, before spending a few weeks and hitting a dead end.

Upvotes: 0

Views: 1674

Answers (1)

Austin Brougher
Austin Brougher

Reputation: 526

SymmetricDS is capable of this.

I've configured a bi-directional sync between MySQL and PostgreSQL. It shouldn't take a couple of weeks to setup a test. Start off by syncing a single table without dependencies.

For a one time import export it is also possible to use the SymmetricDS DbImport DbExport tools.

Upvotes: 1

Related Questions