sql server replication: Applying snapshot does not drop and re-create destination table -- sql server replication

Re: Applying snapshot does not drop and re-create destination table

Raymond Mak [MSFT]
8/20/2003 6:03:29 PM

sql server replication: Perhaps the dummy tables that you created were under a different owner than
the one actually used by the merge agent to create the replicated tables? In
a head-scratchy sort of way, I would expect you to see a spectacular failure
if there is a table schema mismatch between the publisher and subscriber,
rather than having data loaded into the incomplete schema that you created
at the subscriber.

-Raymond

This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Applying snapshot does not drop and re-create destination table

Thomas Born
8/21/2003 10:41:45 AM

Hi
We are using Dynamic Merge Replication and we seem to have a problem with
the intial snapshot.

When trying to apply the snapshot, the process expects the published tables
to exist on the subscriber. I thought it should simply create them if they
don't exist?

Also I have tried to create some dummy tables with the same name, but with
only one column. The snapshot gets delivered but data only appears in that
particular column. I would have expected the destination table to be dropped
and re-created by the snapshot delivery.

I have checked the article definiation and the checkbox indicating "Drop the
existing table and re-create it" is checked for every article on the
snapshot tab. Any idea why this does not work as expected?

Thanks for any help I can get

Thomas
(thomas.born@setac.net.au)