Synch two SQL databases

Last Post 22 Jan 2013 07:23 AM by gunneyk. 2 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
vijay
New Member
New Member

--
21 Jan 2013 09:18 PM
Env: SQL Server 2008 R2

We have two SQL Databases used by two different applications. We need to synchronize some of data between these databases. Both the databases are in Read/Write mode and database structure may be different at source and destination. Records should be synchronized as soon as any DML statement is fired on any of the database. What are the tools/techniques available to achieve this.

Thank
rm
New Member
New Member

--
22 Jan 2013 05:34 AM
Did you take look at replication?
gunneyk
New Member
New Member

--
22 Jan 2013 07:23 AM
Replication would be my first choice as well but if the tables are not identicle that may not be possible. You might want to have a look at Change Data Capture and Change Tracking features both of which can be found in BooksOnLine.
You are not authorized to post a reply.

Acceptable Use Policy