Groups | Blog | Home
all groups > sql server replication > april 2007 >

sql server replication : Replicating to Already Existing Table in Subscriber


Sal
4/5/2007 5:06:01 PM
Hi:

I am trying to replicate a table which already exists in subscriber
database. I want to make sure that I don't overwrite the table schema on
subscriber table. How can I do that? I am using sql 2005. When I add an
article in TSQL, how can I ensure that table schema is not sent across,
however, replication procs such as sp_ins.., sp_ups.., and sp_del.. should be
Paul Ibison
4/6/2007 12:00:00 AM
Have a look at the options on the article properties dialog, "Action if name
is in use" section...
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com

AddThis Social Bookmark Button