October 12, 2011 at 11:37 pm
Hi Friends ,
I am having two database residing on two different server
and i need to synchronize thease two database as bidirectional.
What settings are required to accomplish this task..
Plz Help me ..
October 13, 2011 at 12:50 am
You can use Database mirroring or Replication....
Sagar Sonawane
** Every DBA has his day!!:cool:
October 13, 2011 at 1:04 am
Hi friend,
I think you are right...
please send how to perform mirring or replication processs..
plz send some helpful link..of vedio link to batter understand
whole process..
thanks for your reply..
October 13, 2011 at 2:10 am
i need to synchronize thease two database as bidirectional.
Merge replication is typically used in server-to-client environments. Merge replication is appropriate in any of the following situations:
•Multiple Subscribers might update the same data at various times and propagate those changes to the Publisher and to other Subscribers.
•Subscribers need to receive data, make changes offline, and later synchronize changes with the Publisher and other Subscribers.•Each Subscriber requires a different partition of data.
•Conflicts might occur and, when they do, you need the ability to detect and resolve them.
•The application requires net data change rather than access to intermediate data states. For example, if a row changes five times at a Subscriber before it synchronizes with a Publisher, the row will change only once at the Publisher to reflect the net data change (that is, the fifth value).
Peer-to-peer replication in SQL Server 2008 introduces the option to enable conflict detection across a peer-to-peer topology. This option helps prevent the issues that are caused from undetected conflicts, including inconsistent application behavior and lost updates. By enabling this option, by default a conflicting change is treated as a critical error that causes the failure of the Distribution Agent. In the event of a conflict, the topology remains in an inconsistent state until the conflict is resolved manually and the data is made consistent across the topology.
October 13, 2011 at 7:46 am
As previously mentioned, merge or peer to peer replication will fulfill your needs.
To throw something else out there, depending on the complexity, you could also do this with SSIS.
October 17, 2011 at 11:19 am
Saga... (10/13/2011)
You can use Database mirroring or Replication....
Mirroring is not bi-directional, it is only 1 way.
Thanks,
Jared
Jared
CE - Microsoft
October 17, 2011 at 11:20 am
We use transactional replication with updateable subscriptions. Fundamentally, it is a bi-directional replication.
Thanks,
Jared
Jared
CE - Microsoft
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply