RE: Database Out Of Sync
Do you have an ETL tool, like Datastage for example ? Datastage has the ability to "update existing/insert new", which sounds like what you want to do. Otherwise you could write your own app to do this job. -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of ndmathur@gmail.com Sent: 18 January 2006 05:01 PM To: informix-list@iiug.org Subject: Database Out Of Sync Hi, I'm facing a database out of sync problem in our application and would like the communities help. We have 30 tables in Oracle database and 30 replica tables in Informix (similar schema). We have a process that unloads daily inserts/updates/deletes in Oracle and loads it into the Informix tables. These tables have gone out of sync over the years and requires to be resync'ed asap. On Informix tables, there are insert/update/delete triggers which populate the changes in a corresponding temporary table, hence any activity in the Informix tables fires these triggers and updates the same in temporary tables. A few tables have records in the order of 100,000,000 and other tables also have large number of rows. Our problem is to re-sync the Informix tables with Oracle tables in such a way so that triggers on the Informix tables are fired for the actual records Inserted/Updated/Deleted in the Informix tables (i.e. the actual data which was out of sync). This is required to be done in this fashion so that the temporary tables have only the missed out data over the years and not the full load after the re-sync has been done. This activity would require an outage on our system hence needs to be done in the most efficient manner. I would appreciate your help in guiding me towards a effective solution. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list > The information on this e-mail including any attachments relates to the official business of DigiCare (Pty) Ltd. The information is confidential and legally privileged and is intended solely for the addressee. Access to this e-mail by anyone else is unauthorised and as such any disclosure, copying, distribution or any action taken or omitted in reliance on it is unlawful. Please notify the sender immediately if it has inadvertently reached you and do not read, disclose or use the content in any way. > No responsibility whatsoever is accepted by DigiCare (Pty) Ltd if the information is, for whatever reason, corrupted or does not reach its intended destination. The views expressed in this e-mail are the views of the individual sender and should in no way be construed as the views of DigiCare (Pty) Ltd, except where the sender has specifically stated them to be the views of DigiCare (Pty) Ltd. >