Hi,

I am dealing with merge replication (104 tables/database).
I need to add some new tables in replication. There are two options
1. Stop the replication and publish all tables including new tables then
again set the replication.
2. Create a new subscription for these new tables alone

Advise me, Which one is better?

Thanks,
Soura.

This will cause an complete snapshot to be generated and distributed. A new
publication might be the answer.

--
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
[quoted text, click to view]

SouRa,
you can just add the new table to the existing publication.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

AFAIR, although the new snapshot will include all tables, only the new table
will get distributed.
Cheers,
Paul

Hi,

I think u can add additional articles by using the System SP
sp_addmergearticle .
After you've added it, you run the snapshot agent. This will generate a
complete snapshot but only the new article will be propagated by the merge
agent.

If ur having the MR option as NotSync then have this table exists in
Subscriber also.

Once u tested in test server, u can implement in production.

regards,
Herbert


[quoted text, click to view]