开发者

SQL Synchronization

开发者 https://www.devze.com 2023-01-07 03:50 出处:网络
I have done SQL synchronization. I am to 开发者_开发问答execute the Query like Insert,Update,Delete and it is affecting /reflecting in another PC, but if I create a table it is not replicated in anoth

I have done SQL synchronization. I am to 开发者_开发问答execute the Query like Insert,Update,Delete and it is affecting /reflecting in another PC, but if I create a table it is not replicated in another PC. How do I create a Table that is reflected in another PC which I synchronized.

SQLProduct:MsSql Server 2008

Please help


As far as I know (and I asked the resident expert in replication here to confirm), you need to set up a new article/subscription when you create the new table. SQL Server will not automatically add new tables for you.

You might be able to set up a DDL trigger to do it for you, but honestly I'm not too well versed in replication to know if that's feasible or not.

0

精彩评论

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