将数据从SQL Server数据库复制到另一个数据库 [英] Copy data from sql server database to another database

问题描述

我在sql server 2008中有一个数据库

该数据库由一个应用程序连接，该应用程序在其表上添加，删除和编辑记录


我希望对该数据库上的每个更改都对另一个数据库进行相同的更改，该更改与另一个服务器上另一个sql server 2008上的此数据库类似

有人告诉我，我可以使用sql server 2008中的复制功能来实现它

i have a database in sql server 2008

this data base is connected by an application that add and remove and edit records on its tables


i want for each change on this database the same change happen to another database which is similar to this one on another sql server 2008 on another server

some one told me i can do it using the replication feature in sql server 2008

can any one tell me how to do this?

推荐答案

看看

亲爱的阿米尔，

检查此链接，希望对您有帮助.

Dear Amir,

Check this link, Hope it will help you.

http://blog.sqlauthority.com/2007/08/21/sql-server-2005-create-script-to-copy-database-schema-and-all-the-objects-stored-procedure-functions-triggers-tables-views-constraints-and-all-other-database-objects/[^]

Regards,
AP

除了提供了 djj55 链接外，请查看以下链接以获取更多信息:
CP:SQL Server 2000-合并复制分步过程 [ ^ ]
实施事务复制 [ MSDN:使用SQL Server实施主从快照复制 [ SQL Server复制 [在服务器之间复制数据 [如何实现双向事务复制 [ ^ ]

查看它们，并确定保留数据库副本的最佳方法.

Apart from djj55 link provided, look at these to get more info:
CP: SQL Server 2000 - Merge Replication Step by Step Procedure[^]
Implementing Transactional Replication [^]
MSDN: Implementing Master-Subordinate Snapshot Replication Using SQL Server[^]
SQL Server Replication[^]
Copying Data Between Servers[^]
How To Implement Bidirectional Transactional Replication[^]

Have a look at them and decide on the best way to keep a copy of your database.

这篇关于将数据从SQL Server数据库复制到另一个数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！