SymmetricDS

SymmetricDS was designed as a tool capable of replicating data asynchronously both as an almost real-time operation and a scheduled one. It features support for one-way, multi-master replication, transformations and filtered synchronization.

It can handle a large number of databases, with the possibility of completing tasks between different platforms. Oracle, PostgreSQL, MS SQL Server, MySQL, IBM DB2, Derby, SQLite, MariaDB, Greenplum, Sybase ASE, Amazon Redshift, MongoDB, VoltDB, and more are among the databases across which SymmetricDS can carry out replication processes.

Extension API enables developers to include the software in another program in order to be in charge of replication tasks and provide the user with feedback. What’s more, remote management API should ensure registering new databases, querying the system status, as well as sending data loads can be done.

A multitude of scenarios prove SymmetricDS’ worth. Whether we are discussing situations in which remote offices must be replicated to central headquarters, replication between on-premises databases and cloud databases, consolidation of multiple databases, or cross-platform database replication, the software should handle them all.

Besides, enhancing access times for local users via regional database replication as well as trying to achieve high availability of a database using a primary and secondary instance should raise no issue when resorting to SymmetricDS.