General Discussion > Zero-downtime data migration tool
The only tools I'm aware of are from Celona and Golden Gate (now Oracle).
It's highly unlikely you'll get trial licenses for these however, real-time synchronisation is typically found on high-end solutions so the cost of these products is probably out of your reach if you're looking for something low-cost, I assume you are if you're using MySQl etc.
Tue, August 25 |
Dylan Jones (Founder)
Dylan Jones (Founder)
1. What I am looking for is a Zero-downtime data migration tool that migrates data from staging to production environment. This migration should be a incremental migration, i.e. existing data in the production database should not be removed as part of migration. Of course it can be updated with the staging data. Also, change in table schema and data types in staging should be migrated without any loss of existing data in the production database.
Please note that migration can be between different versions of the same database or between different databases, like:
- SQL Server 2005 to SQL Server 2005
- MySQL to MySQL
- SQL Server 2005 to MySQL
I am also looking for a application\product migration tool with Zero-downtime
2. When X.X version of the product is there in the production and I want to migrate it to a higher version (say X.Y), is there a tool or platform that will allow me to migrate to the higher version with zero or minimal downtime and hence allowing business continuity.
Please let me know if we can get a evaluation copy of the migration tools you can refer.