Wison Ho
Reputation: 83
how to sync production database schemas to DEV and QC in SQL Server?
we now have a hundred of instances(each instance has about 10+ databases) in production environment. and also have DEV and QC environment.
how we could make DEV and QC environment synced with Production periodly?
anyone has a good solution for it?
Upvotes: 0
Views: 202
Answers (1)
Afshin Amiri
Reputation: 3583
take a look at Redgate's SQL compare. https://www.red-gate.com/products/sql-development/sql-compare/index
Upvotes: 1
Related Questions
- How do you Move Dev Database Changes to Production Database?
- SQL Server 2005 - Syncing development/production databases
- Is database replication the way to go to keep production and development databases in sync?
- Oracle: how do I get a copy of the schema of the production DB onto a dev DB
- Tool for synchronising database changes from development database to production?
- How to sync schema continuously in two databases in Sql Server (for unit testing)
- Dealing with schema changes between dev & prod
- Scripts for moving schema changes from development database to production database
- keeping sql database schemas synced between developers
- SQL Server Schema Syncronization