Database migration

Use Repstance when a database moves to a new location or to a different database platform and the business cannot stop while it moves.

How it works

  • A duplicate database is prepared in the new location with ongoing data synchronization: an initial load, then continuous replication. The lag can be checked at any time, and when it is close to zero, users are switched to the new database.
  • If the new database is a different platform, for example Oracle to PostgreSQL, the code (schema, procedures and application code) is converted with a schema conversion tool such as AWS Schema Conversion Tool plus manual conversion. Repstance migrates and replicates the data, applying data type remapping, object naming and transformation rules.
  • The data is validated before the switch: a full comparison when the lag reaches zero, then an incremental comparison, for example daily, that checks only the data changed since the last one. The last incremental comparison is part of the cutover, and differences are repaired with the built-in repair.
  • Repstance supports bi-directional replication, so both databases can stay in use during the migration, which keeps the switch short. With Repstance Advanced Edition, replication can also run from the new database back to the old one, so a legacy application that fails to work with the new database can still work with the old one.

Typical migrations

Two Fintech customer cases on the home page describe such migrations: SQL Server to Aurora PostgreSQL, and Oracle RAC to PostgreSQL with a fallback to Oracle.

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.

Our team works closely with database migration specialists. Support is included during GMT business hours, and 24/7 support is available as a paid Enterprise option (sales@repstance.com). Planning a migration? Contact us and we will help you plan it.

See also: Data validation and repair, Zero downtime upgrade.

Step by step: Zero downtime database migration.