Unidirectional replication in SQL Server 2008

10 pts.
Tags:
SQL Server 2008
SQL Server replication
Can transactional replication be bidirectional?

Software/Hardware used:
SQL SERVER 2008
ASKED: March 25, 2013  2:29 PM
UPDATED: March 25, 2013  4:26 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

In SQL 2008 yes you can have bi-directional transactional replication.  You have to set it up manually using the stored procedures as you need to set the @loopback_detection parameter when running sp_addsubscritpion.  Depending on your requirements peer to peer replication might be a better choice.

Discuss This Question: 1  Reply

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • EdVassie
    The best way to do bi-directional replication in SQL 2008 is Peer to Peer replication (P2P).  This has the advantage over bi-directional transactional replication of supporting schema changes.If you want to put all your SQL and schema updates into a single node, P2P is easy to run.  All the information about quiescing the system can be ignored.  Normally your applications need no changes to run in this type of P2P environment.  We have been using P2P replication using this model for some time, with no significant issues.If you want to put updates into multiple nodes then P2P gets complicated.  Quiescing becomes important for schema changes.  You absolutekly must plan how you will deal with identity ranges if you have multiple node update, and this may mean changes to your applications.
    140 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following