Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

synchronization Expand / Collapse
Author
Message
Posted Thursday, July 16, 2009 10:16 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, January 28, 2016 12:41 AM
Points: 240, Visits: 469
Hi All

I need some help to synchronize two MS SQL databases. The databases are located one in Local server and the other one in the web server.
We need bi- directional synchronization of the databases. Is any solution to synchronize two
databases in the SQL server.
I need some expert advices

Thnx in advance
Milesh
Post #754603
Posted Thursday, July 16, 2009 10:24 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, April 6, 2016 1:53 PM
Points: 2,223, Visits: 3,668
MJ (7/16/2009)

We need bi- directional synchronization of the databases. Is any solution to synchronize two databases in the SQL server.


Can you have a look at peer to peer replication offered in sql server 2005's enterprize edition and see if it suits your requirement.





Pradeep Singh
Post #754607
Posted Thursday, July 16, 2009 10:25 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, December 17, 2015 11:50 AM
Points: 6,050, Visits: 5,314
Transactional Replication perhaps?

CEWII
Post #754608
Posted Friday, July 17, 2009 5:25 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, September 14, 2016 11:46 PM
Points: 1,639, Visits: 1,065
Elliott W (7/16/2009)
Transactional Replication perhaps?

CEWII


Elliott,

What about Merge replication for bi-directional synchronization.





Tanx
Post #754728
Posted Sunday, July 19, 2009 9:18 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Thursday, December 17, 2015 11:50 AM
Points: 6,050, Visits: 5,314
I would think that could work.

If you go down that path sit down and desing out your replication before you start trying to implement it though. I have had much better experiences when I do this.

CEWII
Post #755462
Posted Monday, July 20, 2009 8:44 PM


SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, January 28, 2016 12:41 AM
Points: 240, Visits: 469
Thank u all
Post #756299
Posted Tuesday, July 21, 2009 10:51 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Wednesday, September 14, 2016 11:46 PM
Points: 1,639, Visits: 1,065
Make sure you don't have any conflicting primary keys.


Tanx
Post #757146
Posted Friday, July 24, 2009 6:12 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, April 30, 2012 11:15 PM
Points: 295, Visits: 109
If not intrested in replication you can use triggers and TSQL scripts in SQL jobs to keep your databases in sync.Though it would be good only if you are comfortable with TSQL.
Post #758977
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse