| | |
Zero-downtime Database Migration tool needed
Please support our Database Design advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Jun 2009
Posts: 1
Reputation:
Solved Threads: 0
I am looking for a Zero-downtime Database Migration tool that would provide:
- Migration of data from one version of the application to another version with or without changes to the database schema.
- Migration of data from staging to production where staging was used for beta testing to host customers who created live data which need to be migrated to production. (SQL Server 2005 to SQL Server 2005, SQL Server 2005 to MySQL)
- if a data type changes (say int to varchar) in staging database for a particular column in a table, the change migration should happen in the production database as well
- if a column is added\deleted in a table of staging database, the same table alteration should migrate to production database
- records in production database should not be deleted\truncated during data\schema migration
- demonstrate zero-downtime
Please let me know if you are aware of a tool that provides such features.
- Migration of data from one version of the application to another version with or without changes to the database schema.
- Migration of data from staging to production where staging was used for beta testing to host customers who created live data which need to be migrated to production. (SQL Server 2005 to SQL Server 2005, SQL Server 2005 to MySQL)
- if a data type changes (say int to varchar) in staging database for a particular column in a table, the change migration should happen in the production database as well
- if a column is added\deleted in a table of staging database, the same table alteration should migrate to production database
- records in production database should not be deleted\truncated during data\schema migration
- demonstrate zero-downtime
Please let me know if you are aware of a tool that provides such features.
![]() |
Similar Threads
- Custom Database Admin Tool. (PHP)
- Help needed on reporting (Visual Basic 4 / 5 / 6)
- Help with automatic update problem and more (Viruses, Spyware and other Nasties)
- User accounts migration (Windows NT / 2000 / XP)
- problem after migration (MySQL)
- Backing up a MySQL database (MySQL)
- Move window XP PRO to new Hard drive (Windows NT / 2000 / XP)
- Tool Needed (C++)
- Tool Needed (C++)
Other Threads in the Database Design Forum
- Previous Thread: Sample MLM design
- Next Thread: What is schema?
| Thread Tools | Search this Thread |





