Re: Add table to replicated database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Paul Ibison" <Paul.Ibison@xxxxxxxxxxxxx>
Date: Mon, 24 Oct 2005 19:48:58 +0100

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)

.

References:
- Add table to replicated database
  - From: Dawn

Prev by Date: Add table to replicated database
Next by Date: Need Feedback on Trans. Replication w/ Remote Distributor
Previous by thread: Add table to replicated database
Next by thread: Need Feedback on Trans. Replication w/ Remote Distributor
Index(es):
- Date
- Thread