Why not set up replication between the 2 servers? If you can have both online at the same time, replicate the old server to the new server. It will be ready to go instantly.

Kevin Martin
Sr. Database Engineer
Multimedia Games, Inc.




-----Original Message-----
From: Sanchez Anthony F [mailto:mssqldba-ezmlmshield-x32260993.[Email address protected]
Sent: Wednesday, October 27, 2004 12:03 PM
To: LazyDBA Discussion
Subject: Synchronizing Data

Hi,



I have two SQL servers with identical environments. One is the new machine and the other is our old box which will be disappearing soon enough.



My problem is that our customers will be using the older environment until the developers have made all the necessary changes in their code to make the switch to the new environment.



When they do... the data on the new machine will be several days old.
How can I synchronize the data on the new machine, with the old machine so that the new environment is current?



Many of the tables have FK constraints so I need to account for this.
Should I write a script or use a wizard?



Any help, ideas would be great.



Thanks!



-Anthony



---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY Website : http://www.LazyDBA.com To unsubscribe: http://www.lazydba.com/unsubscribe.html
For additional commands, e-mail: mssqldba-[Email address protected]


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.783 / Virus Database: 529 - Release Date: 10/25/2004


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.783 / Virus Database: 529 - Release Date: 10/25/2004


MS Sql Server LazyDBA home page