Hi DBAs, I am researching for solution for a new project. We have a few tables in Oracle8i db, similar tables with more columns and more data in MS Access. The data is very static.
Our plan is to synchronize the two dbs, from then on we will always put change(adding more columns, or insert new data) in Oracle first, then replicate the change to MS access db in batch process. I am looking for solutions 1) to compare the existing data in Oracle and MS Access 2) to merge the data into Oracle 3) to maintain the two db on ongoing basis. periodically check if they are in synch, then replicate data to MS access. Is there any tool to do the job? any ideas for solution? One solution I thought about is to use MS DTS to put Oracle into Access, then compare..... TIA James -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Xing, James INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
