SQL Server 2008复制分步指导！！！！ [英] SQL server 2008 replication Step by Step Guidance!!!!

问题描述

当SQL Server(2008)中发生事务时，那一刻我希望将数据复制到另一个位置的另一个SQL Server(2008)中.并且如果我对第二台服务器进行任何修改，它应该与第一台服务器自动同步.这两台服务器都可以对datadase进行修改.实际上，我是SQL Server中这种复制方法的新手.应该执行合并复制"还是快照复制"?我不确定执行此任务的最佳方法是什么，因此其他人可以向我解释有关SQL 2008中的复制的逐步指南以及什么是实现此任务的最佳复制方法. ！

When ever transaction occurred in the SQL server(2008) At that moment without a delay i want to replicate that data to a another SQL server(2008) in the different Location. and also if i do any modification to the 2nd server it should auto matically synchronized with 1st server.both the servers could have perform modifications to the datadase. Actually i''m new to this replication methodology in the SQL server.Should i do " Merge Replication" or Snapshot Replication?? i''m not sure what is the best method for this task.so can some one else could explain me the step by step guidance on the Replication in SQL 2008 and what would be the best replication methodology for achieve this task.Thanks in Advance!

推荐答案

看看这些:
视频:如何使用SQL Server 2008设置复制? /a> [ ^ ]

Have a look at these:
Video: snapshot replication sql server 2008 - part 1 - YouTube[^]
Video: How to Setup Replication with SQL Server 2008 ?[^]

嗨..

你可以参考

SQL Server 2005-合并复制的分步过程 [ ^ ]


您可能会有所帮助

Hi ..

u can refer

SQL Server 2005 - Merge Replication Step by Step Procedure[^]


It may be help u

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