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

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: Today @ 8:11 AM
Points: 238, Visits: 366
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: Monday, September 15, 2014 2:38 AM
Points: 2,223, Visits: 3,647
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, May 15, 2014 5:11 PM
Points: 6,032, Visits: 5,283
Transactional Replication perhaps?

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


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, October 28, 2013 8:50 AM
Points: 1,606, Visits: 1,039
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, May 15, 2014 5:11 PM
Points: 6,032, Visits: 5,283
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: Today @ 8:11 AM
Points: 238, Visits: 366
Thank u all
Post #756299
Posted Tuesday, July 21, 2009 10:51 PM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, October 28, 2013 8:50 AM
Points: 1,606, Visits: 1,039
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