Unanswered: Syncing updates betweent two databases
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 .