Merge Replication in SQL2K5

Normally when snapshot is applied only publisher data is downloaded to
subscriber.
Is there a way to have subscriber upload its table data when
synchronization is done for the first time i.e. when snapshot is applied.
Thanks!!!
Perhaps I've misunderstood you, but when the snapshot is applied, the
subscriber's table will be dropped and the associated data lost. If there is
valuable subscriber data that you don't want to lose, then I'd use a linked
server (or DataCompare) to copy it over before publishing the table from the
publisher.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)
|||Paul, Thanks!!!. I want to create the rowguid column at subscriber and start
synchronization without the initial snapshot from publisher.
if i copy the subscribers data to publisher and not apply the initial
snapshot then i think i am ok..
Thanks!!!
"Paul Ibison" <PaulIbison@.discussions.microsoft.com> wrote in message
news:E9219D8F-B39F-4D5B-A20E-1E64477493C9@.microsoft.com...
> Perhaps I've misunderstood you, but when the snapshot is applied, the
> subscriber's table will be dropped and the associated data lost. If there
> is
> valuable subscriber data that you don't want to lose, then I'd use a
> linked
> server (or DataCompare) to copy it over before publishing the table from
> the
> publisher.
> Cheers,
> Paul Ibison SQL Server MVP, www.replicationanswers.com
> (recommended sql server 2000 replication book:
> http://www.nwsu.com/0974973602p.html)
>
|||You can do a nosync initialization. In this case you'll need to have the
rowguid column on the publisher and subscriber with identical values to start
off with. However, possibly the cleanest and easiest solution is to start
with all the data at the publisher and let replication take care of the
transfer.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)