Friday, February 24, 2012

How to do Replication in SQL Server 2005

Hi,

I have two servers with sql server 2005, one is in the main office and the other in a store...

I would like that the items table from the main office send new data to the server at store, and the sales data from the store to be send to the main office, can anyone help me to do that?!

Thanks

moved to replication forum

|||

There are three type of replications in SQL Server

(a) Snapshot

(b) Transactional

(b) Merge

What i feel is you can configure Trasactional replication.

There are many documentation available in net. pse have a look on this

http://blog.csdn.net/longrujun/archive/2006/06/09/783357.aspx

Madhu

No comments:

Post a Comment