InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comTue, 21 May 2013 12:28:03 GMT20http://www.sqlservercentral.com/Forums/Topic1409869-7-1.aspxThen you just need to choose your poison from one of the above methods then.Again depends how much work and how real time you need the data to be transfered from DB1 to DB2.Tue, 22 Jan 2013 02:41:34 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1409869-7-1.aspxhiit is for sql server 2012Tue, 22 Jan 2013 02:40:49 GMTmpradeep23http://www.sqlservercentral.com/Forums/Topic1409869-7-1.aspxTransaction replication would be the best one to go for, just set up the right articles to replicate.Edit, noticed 2012 in the post, is it SQL 2000 or SQL 2012?If 2012Change Data CaptureSSISService BrokerMERGECould also be used depending how much work you want to do and how near real time the updates need to happen and also what edition (Std or Ent) of SQL you are using.Tue, 22 Jan 2013 02:26:49 GMTanthony.greenhttp://www.sqlservercentral.com/Forums/Topic1409869-7-1.aspxI have few tables that needed to be replicated/synchronized across several databases in our SQL Server 2012 .Example:DB1 has T1, T2 and T3 - these are constantly being updated by the application, APP1 running on DB1.DB2 needs to have an updated copy of T1 at all times, also, there is a different application, APP2 runs only on DB2.Both DB1 and DB2 are located on the different instance.Would it be possible to replicate T1, T2 and T3 from DB1 to DB2 ?thanks with best regardspradeepTue, 22 Jan 2013 02:20:17 GMTmpradeep23