SUPPORTED DATABASE REQUIREMENTS

SQL Server  

Currently, Repstance supports versions of Microsoft 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.

Oracle 

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.

PostgreSQL  

Currently, Repstance 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.

MySQL 

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

Snowflake 

The product supports Snowflake as a Target Database only.

RedShift 

The product supports Redshift as a Target Database only.

AWS S3

The product supports AWS S3 as a Target only. The only comma-separated variable and "parquet" file formats are supported.