复制SQL Server 2005 ...请帮助 [英] Replciation Sql Server 2005...Please Help

问题描述

我需要将数据从2个数据库复制到单个数据库中


场景

我们已经为运输公司开发了一个应用程序.他们在两个镇上有两个位置.

我们在每个位置都有一个数据库.

我们需要定期将数据从这些单个数据库转移到集中位置的主数据库中.

什么是上述情况的最佳解决方案


-
谢谢
Anoop Nair

生活是一个挑战，我一直在游戏中取胜.

I need to replicate data from 2 database into a single database


Scenario

We have developed an application for Transport Company. They have two location in two town.

We have a databases at each of locations.

We need to transfer data at regular intervals from these individual databases into our main database at a centralized place .

What would be the best solution for the above scenario


--
Thanks
Anoop Nair

Life is a challenge, and I’m staying in the game to win.

推荐答案

是的，它们通过互联网连接

我们也在尝试在Sql Server 2005中进行复制.

但是我们需要将来自2个不同Db的数据放入一个DB中.

由于身份列和主要ley列，这给我们带来了问题

Yes they are connected via internet

We are also trying for replication in Sql Server 2005.

But we need to get data from 2 different Db''s into a single DB

This is causing us a problem due to indentity column and primary ley columns

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