InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 06:39:58 GMT20http://www.sqlservercentral.com/Forums/Topic754603-1291-1.aspxIf 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.Fri, 24 Jul 2009 06:12:21 GMTVaibhavChoubey@SQLhttp://www.sqlservercentral.com/Forums/Topic754603-1291-1.aspxMake sure you don't have any conflicting primary keys.Tue, 21 Jul 2009 22:51:33 GMTEswinhttp://www.sqlservercentral.com/Forums/Topic754603-1291-1.aspxThank u allMon, 20 Jul 2009 20:44:32 GMTMJ-1115929http://www.sqlservercentral.com/Forums/Topic754603-1291-1.aspxI 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.CEWIISun, 19 Jul 2009 21:18:36 GMTElliott Whitlowhttp://www.sqlservercentral.com/Forums/Topic754603-1291-1.aspx[quote][b]Elliott W (7/16/2009)[/b][hr]Transactional Replication perhaps?CEWII[/quote]Elliott,What about Merge replication for bi-directional synchronization. Fri, 17 Jul 2009 05:25:03 GMTEswinhttp://www.sqlservercentral.com/Forums/Topic754603-1291-1.aspxTransactional Replication perhaps?CEWIIThu, 16 Jul 2009 22:25:35 GMTElliott Whitlowhttp://www.sqlservercentral.com/Forums/Topic754603-1291-1.aspx[quote][b]MJ (7/16/2009)[/b][hr]We need bi- directional synchronization of the databases. Is any solution to synchronize two databases in the SQL server.[/quote]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.Thu, 16 Jul 2009 22:24:55 GMTps.http://www.sqlservercentral.com/Forums/Topic754603-1291-1.aspxHi AllI 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 advicesThnx in advanceMileshThu, 16 Jul 2009 22:16:49 GMTMJ-1115929