Compares and synchronizes SQL database content.
Moderators: JonathanWatts, Chris Auckland, David Atkinson, Michelle Taylor, chengvoon.tong
I am currently working to automate the process of updating our development environment with production schema and lookup table data.
I have figured out how to take a snapshot of production and compare the development environment against that with command line.
My challenge now is to figure out how to take a snapshot of X number of tables in production and compare just those X number of tables in development.
My challenge is that the development environment does not talk to production and the databases are to large to backup/restore.
So my solution is to create RedGate snapshots of schema and hopefully data for only tables I choose and then do the compare and update in development from there.
Any ideas or better suggestions would be appreciated.
- Posts: 3
- Joined: Wed Mar 30, 2011 2:50 pm
- Location: --None--
Return to SQL Data Compare 10
Who is online
Users browsing this forum: No registered users and 0 guests