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.
精彩评论