Hi Smith
What do you mean by [Replication does NOT provide a "complete" database - as
the original.] as far as I know replication can copies all database objects.
If there are any objects that can't be replicated then please let us know.
Regards,
Rakesh
-----Original Message-----
From: Smith Dano
[mailto:mssqldba-ezmlmshield-x52988739.[Email address protected]
Sent: Thursday, October 28, 2004 12:21 AM
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]
MS Sql Server LazyDBA home page