Groups | Blog | Home
all groups > sql server replication > september 2005 >

sql server replication : Replicating data that existed prior creation of replication?



Paul Ibison
9/12/2005 12:10:28 PM
You could set up the old server as the publisher and send it over that way.
If you want it to be a subscriber, you'll need to get the data to the
publisher before starting replication. This could be using DTS, BCP, linked
servers or RedGate's datacompare - they might all be relevant in different
circumstances.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

scotch
9/12/2005 1:22:10 PM
Hello.

I have the following situation: we have one database that contains vital
date, but there isn’t replication between that database and our primary
server.

This is what I have tried: I created merge replication (pull) between
these to databases. Everything went well, but the old data didn’t
replicated. Well I know that replication does work, because new data are
replicated.

Is it normal? If so, than how could we replicate old data? (typing all
the data manually is not an option)

AddThis Social Bookmark Button