Post reply

3 tasks in a transaction - involve 2 data transfers and a batch job

  • July 25, 2006 at 8:40 am

    #103209

    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

    #651503

    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

    #651606

    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