sql server replication: What is best way to update subscriber -- sql server replication

What is best way to update subscriber

Patrick
9/19/2005 5:07:39 PM

sql server replication: Hi Freinds,
SQL 2000

I have a publication with more than 800 articles and so often I get a
structure update for publisher database.Sometime we have new table too. I am
using transactional and merger replications to push the data to 2
subscribers.

What is the best way to update the subscriber with these new structure
changes? I am currently running snapshot again to take care of the changes,
but It take more than 5 hours with that many table and huge amount of data
on tables.

Thank in advance,
Pat

Re: What is best way to update subscriber

Hilary Cotter
9/20/2005 12:00:00 AM

Try sp_repladdcolumn or sp_repldropcolumn. If the schema changes are large
or complex and the tables small you might want to drop the article and readd
it in again.

--
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]