July 9, 2012 at 8:47 pm
Hi All,
I have to setup a bidirectional data synchornization between two database A & B.
Want to know what all options do we have apart from Replication & Triggers.....???????
My Scenario is
If any insert happens in A.table1 it should be copied to B.table 1 & vice versa. Same is for update & delete. I have to take care of transaction concurrency as well.
Inputs/Suggestion would be appreciated !!!
July 10, 2012 at 3:15 pm
Does this syncronization need to be live or once per day?
July 10, 2012 at 3:17 pm
SSIS
bulk copy
redgate data compare
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
July 10, 2012 at 3:28 pm
Take whatever stored procedure is writing to table A and make sure that it also writes to table B. You can do it at the same time using the OUTPUT statement.
Jared
CE - Microsoft
July 10, 2012 at 3:40 pm
Using Jared's method sounds like a good idea if you are trying to do the replication in real-time.
Do be sure and place the operations inside transactions. If the databases are on different servers make sure you get MSDTC setup properly to make sure it all works without issues.
July 10, 2012 at 6:14 pm
SQLRNNR (7/10/2012)
SSISbulk copy
redgate data compare
Thanks Jerry for replying...
It has to be realtime scenario.
July 12, 2012 at 6:22 am
have you looked into Change Tracking or ChangeDataCapture and then using that data to transfer what has changed?
It won't be realtime but it can be near real time.
Without triggers or replication you are really hogtying yourself.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply