问题描述
我有两台计算机,第一台是具有Sql Server 2008的本地计算机,并且有一个数据库,该数据库可以通过对其进行修改的程序来访问
另一台计算机是可以通过网络访问的远程计算机,并且也具有Sql Server 2008,我想在该计算机上放置另一台计算机的数据库副本,我希望在第一台数据库中的每一个更改都在另一台计算机上完成,并且如果连接失败,请等待成功并进行更改
我在Google上搜索了一下,发现我可以使用复制来做到这一点
但我不知道是否使用合并复制或事务复制
有人可以告诉我吗?
I have two computers the first one is a local computer has Sql server 2008 and has a database that is accessed by a program that modify it
the another computer is a remote computer that can accessed over network and has also Sql server 2008 and i want to put a copy of the database of the another computer on this one and i want every change in the first database done in the another one and if the connection failed so wait to be succeed and make the changes
i googled it and i found that i can do it using replication
but i do not know if use Merge replication or transaction replication
can any one tell me?
推荐答案
这篇关于在我的情况下我可以使用哪种复制的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!