Re: Informix & Ingres coresident app's

->From: dssmktg!corinne (Corinne Gregory) ->Subject: Informix & Ingres coresident app's ->Date: Thu, 28 Jan 93 19:01:55 GMT ->Reply-To: dssmktg!corinne (Corinne Gregory) ->Organization: Data Systems Support ->Status: R -> ->Hello... -> -> I have a question about the feasibility of sharing data between two ->applications -- one Informix-based, and one Ingres-based. I'm not up on ->Ingres and SQL-compatibility, but I'd like to make it easier than having ->to do SQL unloads and loads on a periodic basis. Is there an easier (and ->more user-transparent) method? I'm interested in efficiency as much as ->I am in seamless-appearing integration. -> -> Thanks for your help. -> ->- Corinne -> ->Corinne Gregory (corinne@dssmktg.uucp; bangpath - uunet.uu.net!dssmktg!corinne) ->Manager, Development & Support Data Systems Support ->Ph: 714.771.0454 Fax: 714.771.3028 Orange, CA -> One possibility: Write a program in C to run in your crontab. The program should: 1. Connect to one database. 2. Select data into program arrays. ** 3. Disconnect from the database. 4. Connect to other database. 5. Insert saved data into appropriate tables. 6. Disconnect from the second database. 7. If there were any problems, mail a message to your DBA. 8. Quietly go away. ** This assumes the data is of moderate size. If the data is truly huge, then you might want to unload to file(s), and then load from file(s) in step 5. Key points to this approach are: 1. Program runs automatically, via cron. 2. It requires embedded SQL/C products for both DBMSs. 3. Mailing error reports eliminates the need to check on progress; if there was a problem, the DBA will find out upon checking mail. Regards, Alan +------------------------------+---------------------------------------+ | R. Alan Popiel | Internet: alan@den.mmc.com | | Martin Marietta, LSC | ( Please note: My opinions do not ) | | P.O. Box 179, M/S 5422 | ( represent official Martin policy. ) | | Denver, Colorado 80201-0179 | Voice: 303-977-9998 | +------------------------------+---------------------------------------+