Sources: Oracle 10g to 19c and SQL Server (any version that permits CDC, Change Data Capture). With Repstance Advanced Edition, since version 6, also PostgreSQL 12 or later (including Amazon Aurora PostgreSQL) and MySQL 8.0 or later.
Targets: Oracle and SQL Server. With Repstance Advanced Edition also PostgreSQL, MySQL, MariaDB, Aurora (PostgreSQL and MySQL engines), Redshift, Snowflake, Amazon S3 and, since version 6, Apache Kafka (see Editions below).
Databases on Amazon RDS, Azure SQL Database, Azure SQL Managed Instance and Google Cloud SQL for SQL Server, and on EC2 instances or servers of your own. See Supported Database Requirements for the requirements and limits of each database.
Replication
DML and DDL replication in real time: the changes of the included tables, and structural changes such as creating, dropping and renaming tables and changing columns, become part of the replication stream without administrator intervention.
Initial Load while the Source stays in use, with filters, chunks and load options (see Initial Load), or synchronization from a backup of the Source (see Database Sync from Backup).
Restart of the processing from a chosen point in time.
Low impact on the Source: Oracle changes can be read from the redo logs of a standby database, and SQL Server changes from a readable secondary.
Apache Kafka as a Target: the changes are published as JSON messages, one topic for every table (see Replication to Apache Kafka).
Replication topologies:
Uni-direction (one-to-one)
Consolidation (multi target DB support)
Broadcast (one-to-many)
Bi-direction (active-active)
Multi-master (peer-to-peer)
Cascading (N-way replication)
Loopback control (the ability to control data feedback loops).
Can act as a SQL Server replication agent: the NOT FOR REPLICATION option is honored for triggers, identity columns and foreign keys.
Data comparison of the Source and the Target, full or sampled and incremental, with repair of the rows that differ (see Data Comparison).
Transformation and filtering
Transformation (data and objects) with:
the ability to group transformed objects by object name mask (schema name, table name, column name, etc.)
the ability to transform objects based on attributes (primary keys, identity, nullable, default value, etc.)
the ability to transform data and objects driven by DDL and DML statement types
Rules to include, exclude or change DML and DDL operations, by name mask.
DDL replication between different databases: the statements are rebuilt for the Target.
Interfaces
The Web UI, the command line (repcli) and the REST API, for integration with deployment tools such as Terraform.
Editions
Repstance is sold on AWS Marketplace and Microsoft Marketplace in two editions. An on-premises version is available on request.
Repstance Advanced Edition has a 5-day free trial on AWS Marketplace. The AWS infrastructure costs are not included, and the trial becomes a paid subscription unless you cancel it. For a proof of concept with either edition, write to sales@repstance.com.
Apache, Apache Kafka, Kafka and the Kafka logo are either registered trademarks or trademarks of the Apache Software Foundation in the United States and/or other countries. No endorsement by The Apache Software Foundation is implied by the use of these marks.