943,744 Members | Top Members by Rank

Ad:
Jun 30th, 2009
0

Zero-downtime Database Migration tool needed

Expand Post »
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.
Similar Threads
Reputation Points: 10
Solved Threads: 0
Newbie Poster
tarakg is offline Offline
1 posts
since Jun 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Database Design Forum Timeline: Sample MLM design
Next Thread in Database Design Forum Timeline: What is schema?





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC