Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Bi-Transcational replication Via script Expand / Collapse
Author
Message
Posted Sunday, December 22, 2013 1:08 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, October 25, 2014 10:52 AM
Points: 9, Visits: 54
Hello All,

Will you please provide me the good link to replication on two servers?


help
Post #1525330
Posted Monday, December 23, 2013 11:23 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
Do you mean bi-directional?

Refer following link:
http://social.technet.microsoft.com/Forums/sqlserver/en-US/dd610c7e-8d13-4679-b061-56503a4a2fd1/sql-server-2012-an-d-bidirectional-transactional-replication

HTH


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1525688
Posted Monday, December 30, 2013 5:00 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Monday, August 18, 2014 3:04 AM
Points: 1,331, Visits: 15,269
If you mean bi-directional in the form of transactional replication, you should go down the route of peer to peer replication. I'd stay away from updatable subscriptions as that's not true replication.

http://www.sqlskills.com/blogs/paul/sql-server-2008-configuring-peer-to-peer-replication/
http://technet.microsoft.com/en-us/library/ms146914(v=sql.105).aspx

The alternative to this is merge replication.
http://technet.microsoft.com/en-us/library/aa337473.aspx
Post #1526456
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse