SQL Synchronization
-
We are a small organization with limited funds at this time and I am looking to find a way to synchronize production and development databases using Query Analyzer. Is anyone familiar with this? And can you help a novice DBA understand the process?
-
For something that runs in Query Analyzer to synchronise data, or even better as stored procedures. You'll be wanting to run a series of DELETE, UPDATE and INSERT statements across each of the tables.
DELETE records from dev that are no longer in production. UPDATE records in dev that have changed in production and INSERT records into dev that don't already exist.
--------------------
Colt 45 - the original point and click interface
-
What I've done is performed a backup of the live servers and restored them on the development machines. You can use the backup and restore commands in query analyzer. It would then just be a matter of copying the backups (which I guess you can even do in query analyzer). If the databases are used in replication, try to get the backups to all perform at the same time. Also, use the KEEP_REPLICATION switch with your restore. I'm actually doing all of this right now to set up my development server.
-
Thank you both. I will look into these. Of course, if it gets too time consuming, I may be able to convince them it is worth investing in one of the commercial synchronization programs.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply