Bucardo vs DBSync

Bucardo is a free, open-source system for asynchronous PostgreSQL replication in multi-source and multi-target arrangements. It supports multi-way synchronization and one-direction master-standby replication. Users define named syncs that copy selected tables between a server and other servers. A Perl daemon listens for NOTIFY requests and connects to remote databases to copy data. Multi-source setups can use a standard conflict handler or a custom handler assigned per table. Configuration and replication databases require PostgreSQL 8.1 or later, while the configuration database also needs PL/pgSQL and PL/PerlU. The daemon needs a Unix-like operating system, is tested mainly on Linux and macOS, and does not run natively on Windows. Installation is available from source, RPM or Debian packages, and FreeBSD Ports. Bucardo does not replicate DDL or schema changes. The listed latest release is 5.6.0.

DBSync automates data replication, consolidation, and capture of changes between systems. It supports real-time, two-way database synchronization through change data capture (CDC), and can replicate Salesforce, Dynamics 365, and Business Central data to databases, data lakes, and warehouses. Data Compare helps find mismatches between datasets for comparison and consolidation. Jobs can run on a schedule or in response to events; supported methods include CDC, ELT, ETL, and Reverse ETL. Deployment options include on-premise and cloud-hosted setups. Listed endpoints include SQL Server, SQLite, MySQL, PostgreSQL, Oracle, IBM Db2, MongoDB, Snowflake, AWS Redshift, AWS S3, Azure Synapse, Databricks, and MinIO. Documentation lists Batch API and J2EE Web Server modes, with EXE, Zip, Docker, and AWS Images deployments. A free Developer plan includes two connectors, up to 10,000 records, and up to three objects. A 14-day trial includes plan features and up to two standard connectors. Paid plans require an annual contract, and add-ons may cost extra.