SymmetricDS is an open source, feature rich, web-enabled, database independent, data synchronization/replication software. It is written in Java 5 and released under GNU Lesser General Public License (LGPL) version 3.
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 is preserved.
MySQL version 5.0.2 and above
Oracle version 8.1.7 and above
PostgreSQL version 8.2.5 and above
Sql Server 2005
Apache Derby 10.3.2.1 and above
IBM DB2 9.5
Firebird 2.0 and above
SymmetricDS allows for 2-tier and even n-tier synchronization, which can be configured to push data (trickle-back) or pull data (trickle-poll) at an interval, as illustrated below:
The software is installed either standalone, as a web application in a Java application server or can be embedded into another Java application.
SymmetricDS will be useful for data synchronization between a central database and multiple remote databases. This kind of requirement is often in:
- HQ and branches
- General office and retail outlets
- Police HQ and stations
- Ministry of education and schools
- Ministry of health and hospitals & clinics
Click here for more information about SymmetricDS.