Monday, February 20, 2012

Replicating Schema only

Hi,

I have a database that is being set up for merge replication (Sql 2005), but there is one table that I only want the schema replicating, not the data - I never want the data to be replicated in either direction. I can see from sp_addmergearticle that you can do something like this for sp's or functions but is it possible to do this for tables?

Regards

Graham

I'd just script out the object to a file and specify parameter @.post_snapshot_script to proc sp_addmergepublication.

No comments:

Post a Comment