SymmetricDS

SymmetricDS: Open Source Database Syncing Software

SymmetricDS is an open source software for syncing data between databases, supporting heterogeneous database types and bidirectional propagation through transaction logs.

What is SymmetricDS?

SymmetricDS is an open source software application designed to sync data between databases. It supports syncing data between heterogeneous database types like MySQL, PostgreSQL, Oracle, SQL Server, etc. and works by capturing data changes from the database transaction logs and propagating those changes to destination databases bidirectionally.

Some key features of SymmetricDS include:

• Platform independent, written in Java
• Supports syncing between both homogeneous and heterogeneous database types
• Bidirectional synchronization between databases
• Configuration-based, allows syncing specific tables or entire databases
• Conflict detection and resolution strategies
• Data filtering and routing options
• Transaction awareness and guaranteed delivery
• Web-based user interface for monitoring and management
• REST API for integration

SymmetricDS is useful for replicating data between databases across data centers, systems, or cloud environments to ensure high availability. It can handle fairly large data volumes efficiently. Typical use cases include database sharding, multi-master replication, and offloading reporting databases.

As an open source solution, SymmetricDS provides capabilities comparable to commercial products like Oracle GoldenGate or Attunity Replicate at a much lower cost. It requires some expertise to set up and manage but can enable more affordable database replication and synchronization architectures.

SymmetricDS Features

Official Links