July 25, 2006 at 8:40 am
I have 2 databases A and B. Data needs to be transferred from some tables in A to B (changes (insertion, updation and deletion) need to be updated). After this is done, a batch job needs to run on B. Once this succeeds, the data from a different set of tables in B need to be transferred to A. Failure in any step should rollback all the changes. What is the best way to accomplish this?
Thanks
July 25, 2006 at 4:40 pm
You could create a job to do this. and use DTS packages to transfer data or even stored procs depending on the type of transfer - plain or with some manipulation.
You could do replication from A to B but that will only solve one of your requirements. You still need to write your code and find a way to run the batch job and (2) transfer data from B to A. Remember any changes to A will be propagated to B if there is a replication so you might see the data back into B.
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
July 26, 2006 at 7:10 am
Thank you very much for the response Dinakar. We have decided to solve this using a DTS package.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply