Use Repstance when a new version of an application has to go live without stopping the current one (blue/green upgrade).
How it works
- A duplicate database is prepared and the new version of the application is installed in it, with continuous synchronization of user data. Once the database is upgraded and in sync, the users are switched to the new version.
- Repstance replicates data between databases that have different structures.
- Repstance supports various types of transformations, with the ability to customize the data and database objects that are processed, in order to support the logic of the new version.
Zero downtime upgrade is different from zero downtime migration: the target database can have a new version installed and the schema definitions may be different. By using transformation, Repstance modifies the statements to meet the requirements of the new version.
See also: Database migration.
Step by step: Zero downtime database migration.