SymmetricDS is open source database synchronization software that is web-enabled and database independent for change data capture, data replication, and data transformation. It uses web and database technologies to replicate tables between relational databases in near real time. The software was designed to scale for a large number of databases, work across low-bandwidth connections, and withstand periods of network outage. By using database triggers, SymmetricDS guarantees that data changes are captured and atomicity of transactions is preserved. A database dialect abstraction makes it easy to support new databases, with current implementations for Oracle, IBM DB2, MS SQL Server, MySQL, Informix, Interbase, PostgreSQL, Firebird, Apache Derby, HSQLDB, H2, and Greenplum included. Synchronization can be configured to push data (trickle-back) or pull data (trickle-poll) at an interval. SymmetricDS allows for 2-tier and even n-tier synchronization. A professional version of the data replication engine includes a graphical web console for configuration, monitoring, and troubleshooting, which is backed by commercial support for resolving issues in production.
Deployment options include the following:
- Web application archive (WAR) deployed to an application server such as Tomcat, Jetty, or JBoss
- Standalone service
- Embedded in an application
SymmetricDS is written in Java and licensed as open source software under the GNU Lesser General Public License (LGPL).