4.1 MS SQL Server Database

Currently the product supports versions of MS SQL Server that permit the use of CDC (Change Data Capture) as a Source Database with the following limitations:

• A system databases are not supported,
• No Contained databases are supported,
• No databases enabled with In-Memory Optimization (2014/2016 feature) are currently supported,
• Database Compatibility level must be 100 or higher,
• Asynchronous AlwaysOn databases are not supported,
• The SQL Server Agent must be running.

Any SQL Server databases starting 2008, including RDS and Azure SQL Server instances, are supported as a Target Database.

The RDS and Azure SQL Server instances are supported for Source and/or Target Databases.

4.2 Oracle Database

Currently Repstance supports Oracle versions 10g through 19c including RAC configuration as Source and/or Target Database. Both EC2 and RDS instances are supported.

The Oracle Source Database must be configured to run in ARCHIVELOG mode prior to use. It is recommended practice to ensure that the archive logs are not “cleaned-up” until they are processed by the Repstance Server. At least the “minimal supplemental logging” needs to be enabled either prior to use or as a part of “prepare database” command.

4.3 MySQL Database

Currently the product supports MySQL as a Target Database only. The following versions are supported:

• MySQL versions 5.5-5.7
• MySQL 8.0
• Aurora MySQL
• MariaDB versions 10.0 – 10.3

4.4 PostgreSQL Database

Currently the product supports PostgreSQL as a Target Database only. The following versions are supported:

• PostgreSQL versions 10.1-11.6
• Aurora PostgreSQL compatible with PostgreSQL 10.x.

4.5 Snowflake Database

Currently the product supports Snowflake as a Target Database only.