Tuesday, March 27, 2012

Dropping and Creating of a Table.

I have what, hopefully, is a simple question. Do any of the methods
of replication for SQL 2000 support the dropping and creating of a
table and have it replicated to the remote system?
Brandon,
I'm assuming you're talking about an existing publication. In transactional
this is possible using sp_addarticle, sp_addsubscription,
sp_refreshsubscriptions and the corresponding drop commands for the
converse. As far as I recall, snapshot also behaves this way but not merge.
I'll test this when I get a moment.
Rgds,
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