synchronization

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server Newbies » synchronization

synchronization

Rate Topic

Display Mode

Topic Options

Author

Message

MJ-1115929

Posted Thursday, July 16, 2009 10:16 PM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, January 16, 2013 1:22 AM
Points: 229, Visits: 294

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

ps.

Posted Thursday, July 16, 2009 10:24 PM

SSCrazy

Group: General Forum Members
Last Login: Thursday, May 02, 2013 2:32 AM
Points: 2,236, Visits: 3,620

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

Elliott Whitlow

Posted Thursday, July 16, 2009 10:25 PM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:02 PM
Points: 5,854, Visits: 4,873

Transactional Replication perhaps?

CEWII

Post #754608

Eswin

Posted Friday, July 17, 2009 5:25 AM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 4:19 AM
Points: 1,593, Visits: 1,025

Elliott W (7/16/2009)

Transactional Replication perhaps?

CEWII

Elliott,

What about Merge replication for bi-directional synchronization.

Tanx BigGrin

Post #754728

Elliott Whitlow

Posted Sunday, July 19, 2009 9:18 PM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 24, 2013 12:02 PM
Points: 5,854, Visits: 4,873

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

MJ-1115929

Posted Monday, July 20, 2009 8:44 PM

SSC Veteran

Group: General Forum Members
Last Login: Wednesday, January 16, 2013 1:22 AM
Points: 229, Visits: 294

Thank u all

Post #756299

Eswin

Posted Tuesday, July 21, 2009 10:51 PM

SSCommitted

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 4:19 AM
Points: 1,593, Visits: 1,025

Make sure you don't have any conflicting primary keys.

Tanx BigGrin

Post #757146

VaibhavChoubey@SQL

Posted Friday, July 24, 2009 6:12 AM

SSC 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 »

Permissions