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


MS Sql Server LazyDBA home page