Bucardo vs Oracle GoldenGate

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.

Oracle GoldenGate is a data replication service supporting change data capture and multi-way movement between databases. It offers hybrid deployment, cross-region replication, and data transformations. Supported systems include Oracle Database, MySQL, PostgreSQL, Microsoft SQL Server, Db2 LUW, Db2 z/OS, Db2 for i, Sybase, Teradata, Yugabyte, TimesTen, MongoDB, and Cassandra. Oracle GoldenGate Free provides a free perpetual license, a recipe-driven interface, and Docker deployment. OCI GoldenGate is listed at $1.34 a month, with each partial OCPU hour billed as a full hour and usage of 1–24 OCPUs. OCI GoldenGate BYOL is a bring-your-own-license route for on-premises users, with pricing not publicly listed on the opened pricing page. The service is available on Linux and the web. Oracle was founded in 1977 and is headquartered in Austin, Texas, USA.