data gets appended on subscriber

Hello NG,
I need a Replication(Snapshot) from a MS-SQL Server 8 to another MS-SQL
Server 8.
With the help of the wizard I set everything (origen, destination,
publication etc.) up.
The replication (seems) to run correctly but my problem is, that the
data gets appended on the Subscriber. But I want the data to be overwritten.
Under properties of the publication and then articles, I can determine
the behavior of the snapshot: In case the table exists on the Subscriber
the 1) table can be deleted and re-created or 2) all data of the table
can be deleted. I tried both options with my tables but the data was
still appended.
Does anyone have an idea how I can change this behavior? Thanks a lot in
advance.
Cheers
The only way this could happen is
1) you are using the additive conflict resolver with merge replication
2) your snapshot is configure to keep the existing table intact. To check
this right click on your publication, select the articles tab, click on the
problem article, and in the snapshot tab, select the delete option
Hilary Cotter
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
"Martin Miethe" <mmiethe@.protours.cl> wrote in message
news:431f6898$0$24148$9b4e6d93@.newsread4.arcor-online.net...
> Hello NG,
> I need a Replication(Snapshot) from a MS-SQL Server 8 to another MS-SQL
> Server 8.
> With the help of the wizard I set everything (origen, destination,
> publication etc.) up.
> The replication (seems) to run correctly but my problem is, that the
> data gets appended on the Subscriber. But I want the data to be
overwritten.
> Under properties of the publication and then articles, I can determine
> the behavior of the snapshot: In case the table exists on the Subscriber
> the 1) table can be deleted and re-created or 2) all data of the table
> can be deleted. I tried both options with my tables but the data was
> still appended.
> Does anyone have an idea how I can change this behavior? Thanks a lot in
> advance.
> Cheers
|||Hilary Cotter wrote:
> The only way this could happen is
> 1) you are using the additive conflict resolver with merge replication
> 2) your snapshot is configure to keep the existing table intact. To check
> this right click on your publication, select the articles tab, click on the
> problem article, and in the snapshot tab, select the delete option
Thanks for your answer, seems to work fine now.
Cheers