开发者

SQL Synchronization

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜