all groups > sql server replication > august 2007 >
You're in the

sql server replication

group:

Synchronizing data prior to initial snapshot



Synchronizing data prior to initial snapshot sonyan NO[at]SPAM gmail.com
8/23/2007 3:38:54 PM
sql server replication: Hello folks,

I am trying to set up replication between a central office and
multiple sites. This will be merge repl, since either central or
satellites can be modified. However, one issue I ran into is setting
up subscribers. I don't always have the option of starting with a
publisher's snapshot; some of the subscribers have their own data
already, which may or may not overlap with central site, and which
needs to be synchronized into the central site somehow.


So far, I haven't seen any solution for this kind of scenario, at
least nothing out of the box. Am I doomed to having to roll out custom
data transfers (I don't think I can use DTS since all sites are
running Express), or is there some standard way of doing this?



Thanks so much!



Sonya
Re: Synchronizing data prior to initial snapshot Hilary Cotter
8/24/2007 7:25:04 AM
Set up merge replication using a no sync, then use sp_addtabletocontents on
each subscriber to send all the data to the publisher. Only the data on the
subscriber that the publisher does not have will be inserted on the
publisher.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]

AddThis Social Bookmark Button