Sunday, March 11, 2012

Add table to replicated database

How do I add a table to a replicated database using the Enterprise
Manager? I know to use the Publications properties to add a column,
but want to be sure to add a table correctly.
It's the same dialog box. Click the checkbox to show unpublished articles
and then select the table. In this sense it is different to adding a column,
as the table must already exist. After that, run the snapshot agent to
create the bcp files for the table. If the publication is a merge one, a
complete snapshot is created although only the new table will be used. On
synchronization, just the new article will be sent to the subscriber.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

No comments:

Post a Comment