Hi KM
What are other possible options to perform this task?
Regards,
Rakesh
-----Original Message-----
From: Kevin Martin
[mailto:mssqldba-ezmlmshield-x96520913.[Email address protected]
Sent: Thursday, October 28, 2004 12:31 AM
To: LazyDBA Discussion
Subject: RE: Synchronizing Data
Replication would work as long as the DB objects are the same on both
servers. With that said, I do typically use either backup/restore or
detach/attach. I was just throwing replication out there as another
possible option.
-km
-----Original Message-----
From: Smith Dano [mailto:mssqldba-ezmlmshield-x52988739.[Email address
protected]
Sent: Wednesday, October 27, 2004 1:51 PM
To: LazyDBA Discussion
Subject: RE: Synchronizing Data
Replication does NOT provide a "complete" database - as the original.
So you would NOT be ready to go instantly...
Backup/Restore...
-----Original Message-----
From: Kevin Martin
[mailto:mssqldba-ezmlmshield-x18198733.[Email address protected]
Sent: Wednesday, October 27, 2004 2:49 PM
To: LazyDBA Discussion
Subject: RE: Synchronizing Data [faked-from]
Importance: Low
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
---------------------------------------------------------------------
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]
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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]
MS Sql Server LazyDBA home page