在我的情况下我可以使用哪种复制 [英] which replication can i use in my situation

问题描述

我有两台计算机，第一台是具有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?

推荐答案

这确实取决于您的数据库负载.即有多少人在使用它，以及针对它进行过多少次粗暴操作.

对于需要有效镜像并且频繁进行事务处理(交易操作)的数据库，则选择事务复制.如果要在一天结束时合并数据库，并且镜像不需要是实时"的，则应使用合并复制.

This really depends on your database load. i.e. how many people are using it and how many crud operations are made against it.

For a database that needs to be effectively mirrored and where transactions (crud operations) are frequent then transactional replication is the one to choose. Merge replication should be used when say, you want to merge the database at the end of the day and where the mirroring does not need to be "real time".

http://beyondrelational.com/quiz/sqlserver/general/2010/questions/sqlserver-quiz-general-2010-vidya-sagar-merge-replication-v/s-transactional-replication-with-update.aspx[^]

这篇关于在我的情况下我可以使用哪种复制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！