SymmetricDS is database replication and file synchronization software. It is a platform-independent, web-enabled, and database-agnostic synchronization tool. With initial data load, bidirectional change data capture, conflict resolution, and data transformation, it is a comprehensive data replication solution.
Features
- Database Independent - Supports: Oracle, MySQL, PostgreSQL, Microsoft SQL Server, Microsoft Azure, H2, IBM DB2, Firebird, Informix, Greenplum, and more
- Transaction Aware - Data updates are recorded and replayed with the same atomicity
- Guaranteed Delivery - Synchronized data is guaranteed to arrive at the target destination. If a synchronization fails, the same batch of data will be retried until it succeeds or manual intervention is taken. All other data synchronization is halted for the failed channel only.
- Conflict Management - Data conflicts can be detected and resolved
- Data Transformation - Data can be transformed to load into different structured tables
- Channels - Tables are grouped into independent channels with prioritization, quality of service, and threading
- Central Configuration - All configuration is downloaded from a central registration server
- Data Filtering - Allows for localized passwords and sensitive data filtering
- HTTP Transport - Leverages proven web technology for scalability
- Initial Data Load - Prepare the target database with an initial or partial load of data
- Communication Links - Push or Pull data to control communication and work across firewalls
- Efficient Data Protocol - A fast streaming data format that is easy to generate, parse, and load
- Active-Active - Use two-way, bidirectional, or active-active configuration to keep multiple databases in sync
- Primary Key Updates - Captures the "before" and "after" data being changed, allowing updates to primary key data
- Payload Compression - Optionally compresses data on transport
- Extendable API - Add customizations through extensions and plug-in points
- Auto Database Creation - Optionally allow creating and upgrading of database schema
- Multiple Deployment Options - Standalone engine, web application, embedded software component
- Embeddable - Small enough to embed or bootstrap within another application
- Remote Management - Administration through a Java Management Extensions (JMX) console or REST
- Remote Database Administration - SQL can be delivered and run at remote databases via the synchronization infrastructure
- Android Support - Independent client that works on Android
- File Synchronization - Sync files as well as data
License
GNU General Public License version 3.0 (GPLv3)
You Might Also Like
Rate This Project
Login To Rate This Project
User Reviews
-
It does what it promises, but the free version is almost undocumented
-
Very effective tool.
-
Perfect choice for data and file replication in Java Applications