Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2004

    Syncing updates betweent two databases

    I have posted this question in Informix forum too. But I thought its more suited here so I am duplicating it here. Thanks.

    I am writing an appliation which has to update similar fields on two databases. Due to legacy system and bad design they are on different servers and you ahve to go and explicitly add the changes in both.

    So I need to change both adn in the end make sure both the changes are good otherwise roll back. Is there any standard method to do such a thing ? Even an abstract description would be helpful. I was thinking in terms of runnign a select querry on both of em adn comparing the results, but I have a feeling that it may be heavy weight and stupid .

    Thanks, a lot

  2. #2
    Join Date
    Mar 2001
    Lexington, KY
    Sybase Replication Server operates with Informix, from what I recall. Otherwise you might want to see if Informix has a replication product (I bet they do) to replicate changes from one DB to another.


  3. #3
    Join Date
    Sep 2004
    Thanks for the reply .I doubt whether we have such a product. Its a bare bones database, here and I will have to take care of the programatically. Is there a standard procedure peopel use for such a thing?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts