July 1, 2008 at 10:25 pm
Hey Guys,
I have some tables on one instance that I would like to update with data from their counterpart tables on another instance, on a regular basis. Currently, I'm using the Transfer SQL Server Objects task, but I was wondering if there is another way that appends new data or updates any changes to the destination from the source tables.
Jafar
July 2, 2008 at 3:53 am
It may be possible to write INSERT/UPDATE/DELETE triggers in the source database tables to update the equivalent destination database tables
However, I'd guess it could put a strain on resources if the tables are frequently changed
July 2, 2008 at 5:46 am
Replication would be an option, or possibly mirroring / database snapshot.
Also, if you like using SSIS, you could use the Slowly Changing Dimension transformation, a merge join / conditional split approach, or download the TableDifference component from http://www.sqlbi.com/[/url]
It will depend on how many tables, how many records, the latency you can have, the amount of system resources the process can consume, if the data needs to be updatable, etc.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply