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

About moving data between databases Expand / Collapse
Author
Message
Posted Tuesday, January 22, 2013 2:20 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 3, 2014 11:44 AM
Points: 69, Visits: 307


I 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 regards
pradeep
Post #1409869
Posted Tuesday, January 22, 2013 2:26 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, October 13, 2014 6:42 AM
Points: 5,216, Visits: 5,111
Transaction 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 2012

Change Data Capture
SSIS
Service Broker
MERGE

Could 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.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1409873
Posted Tuesday, January 22, 2013 2:40 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 3, 2014 11:44 AM
Points: 69, Visits: 307
hi

it is for sql server 2012
Post #1409879
Posted Tuesday, January 22, 2013 2:41 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Monday, October 13, 2014 6:42 AM
Points: 5,216, Visits: 5,111
Then 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.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1409880
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse