Zero-downtime Database Migration tool needed

Reply

Join Date: Jun 2009
Posts: 1
Reputation: tarakg is an unknown quantity at this point 
Solved Threads: 0
tarakg tarakg is offline Offline
Newbie Poster

Zero-downtime Database Migration tool needed

 
0
  #1
Jun 30th, 2009
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.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the Database Design Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC