Real-time replication

Use Repstance when changes made in one database have to reach another within seconds or minutes, in high volume and without slowing the source down.

What Repstance does

  • Reads the changes of the source database and applies them to the target in real time, keeping the target consistent with the source. DDL changes are replicated too.
  • Starts with an initial load and continues with ongoing replication, or is used for a one-time migration.
  • Maps objects automatically, so a replication project is simple to set up. Transformation and filtering let the source and the target have different structures.
  • Built-in data validation and repair let you compare source and target and fix any differences.
  • Scales to large databases while maintaining accuracy. In the Oracle benchmark the changes reach Aurora PostgreSQL 11 seconds late on average and 19 seconds at most at 4,250 transactions per second (Benchmark).

Typical uses

  • Decision-support systems in business-critical environments, where fresh data has to reach the live environment within seconds to minutes and in high volume
  • Data warehouse systems that require fast, continuously synchronized data transfers and high availability
  • A second, continuously updated copy of your data on another database, which protects you from losing it if the source fails
  • Any system that requires high volumes of data transfers in real time

Sources: Oracle 10g to 19c, any version of SQL Server that permits CDC and, with Repstance Advanced Edition, PostgreSQL and MySQL.
Targets: Oracle, SQL Server, PostgreSQL, MySQL, MariaDB, Amazon Aurora, Amazon Redshift, Snowflake, Amazon S3 and Apache Kafka. All targets except Oracle and SQL Server need Repstance Advanced Edition.

Repstance is available as a cloud solution in the AWS and Azure marketplaces and as an on-premises deployment. Support is included during GMT business hours; 24/7 Enterprise support is a paid option (sales@repstance.com).

See also: Database migration, Reporting, analytics and data lake feeds, Data validation and repair.