SQL SERVER 2008复制/同步 [英] SQL SERVER 2008 REPLICATION/ Synchronization

问题描述

大家好，

通过创建合并类型的发布，我们正在将数据库与中央服务器同步.
我面临的问题是我在表中添加了新列.该表已发布.现在，当我尝试更改已添加的新列中的任何值并尝试进行同步时，它会弹出一条错误消息，提示同步失败.

如果其他列的值已更改且已完成同步，则同步"过程会弹出冲突"消息，并选择获胜者并进行更新.
为什么我的专栏文章没有出现这种情况.

问候，
Saurabh Abhyankar

Hi guys,

We are synchronizing our data base with the central server by creating Publications of merge type.
The problem i am facing is that i have added a new column to a table . This table is published. Now when i try to change any value in the new column that i have added and try to synchronize then it pops a error saying Synchronization failed.

If the values of other columns are changed and synchronization is done then the Synchronization process pops a Conflict message and selects the winner and updates.
Why this is not happening for my column.

With Regards,
Saurabh Abhyankar

推荐答案

要同步数据库，需要确保双方(在中央服务器和数据库上)都具有相似的数据库.如前所述，您已经在数据库中添加了一列，因此请确保在中央服务器上也有类似的列.

我建议您使用 Microsoft Sync Framework [

Hi,

To Synchronize your database you need to make sure you have similar database on both the side (on central server and your database). As you have mention, you have added one column in your database so make sure you have similar column on central server.

I recommend you to use Microsoft Sync Framework[^] to synchronize your database.

Hope this information helps you,

Thanks
-Amit Gajjar

这篇关于SQL SERVER 2008复制/同步的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！