开发者

Change Database Structure on Table being Replicated

开发者 https://www.devze.com 2023-03-14 14:48 出处:网络
I need to make structure changes to a database that is part of a subscription that is using Transactional Replication.

I need to make structure changes to a database that is part of a subscription that is using Transactional Replication.

I am wondering if I take the Datab开发者_高级运维ase out of the Article list, make the changes on the Master server then do a Snapshot to reinitialize the subscribers.

Will that work, or is there something else I should do to get this resolved.


I think SQL Server 2005 replicates schema changes as well. See http://technet.microsoft.com/en-us/library/ms151870.aspx

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号