SqlServer2008 R2发布订阅

网上好多大神写的贴子,自己也看着贴子弄的,写的已经很详细了,我就不重复写了,贴上参考资料:

http://www.cnblogs.com/dudu/archive/2010/08/26/1808540.html

https://www.cnblogs.com/lxblog/archive/2012/11/08/2760650.html

 

SqlServer同步后,在不重新初始化快照的情况下新增表:

https://www.cnblogs.com/datazhang/p/5498789.html

 

use XX_WB_XXX ;
go
EXEC sp_changepublication
@publication = 'XX_WB_XXX_Publisher',
@property = 'allow_anonymous' ,
@value = 'false'
GO
EXEC sp_changepublication
@publication = 'XX_WB_XXX_Publisher',
@property = 'immediate_sync' ,
@value = 'false'
GO

 

需要注意的是,两台做发布订阅的服务器,必须都新建一个同名的账户,而且密码要相同!!

posted @ 2017-12-08 10:20  小丑不戴面具  阅读(45)  评论(0编辑  收藏