Is it possible to start replication (merge) using all tables and then later
restrict the tables that will be replicated? Thanks.

David

"David C" schrieb:
[quoted text, click to view]

Yes, you can remove articles from existing publications - but why would you
want to do that? It will create a new snapshot, reinitialize all subscribers,
and you don't save anything. Try to decide the needed tables before the first

OK, but if I add tables to the database later will I have to do anything
to include them in the next synch?

David

"David" schrieb:
[quoted text, click to view]

Of course - add them to the publication and reinitialize the subscribers.
That's it.

A constant automatic recognition (and addition to the publication) of new

So the key would be to "synch" all subscribers first, then add the table,
then create (replace?) all subscribers? Thanks.

David

"Christian Donner" <ChristianDonner@discussions.microsoft.com> wrote in
message news:22A55B87-004F-47F9-B1DC-913B9C9FC7AD@microsoft.com...
[quoted text, click to view]

David,
with merge replication (unlike transactional) you can't remove tables from a
publication without reinitializing once there are some subscribers who have
initialized. Adding new tables to the publication is possible, but you'll
have to run the snapshot agent then just the new article (table) will be
propagated on synchronization with the subscribers. If you don't want to run
the snapshot agent again, you can add the table to a new publication.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)