SQL Server Performance

Suggest a "Replication" type

Discussion in 'SQL Server 2005 Replication' started by mboo, Aug 11, 2009.

  1. mboo New Member

    I would like to have some suggestions on the kind of "Replication" which would be apt for the following scenario:
    The DB Servers are SQL server 2005. We have few DB servers for different regions and a common DB server. When the user wants to Sync the data, he can connect his DB server with the common server and do the same. The process can be done automatically or manually. The sync should be bi-directional. It can be done from any of the DB servers. The ultimate aim is to share all the DB server data via the common DB server.
    Thanks in advance.
  2. preethi Member

    Can anyone alter any data?
  3. preethi Member

    Just to rephrase the question:
    Can any one (user from any location) alter any data - including the data not originated from his/her location?

Share This Page