Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Interbase / Oracle Communication

Re: Interbase / Oracle Communication

From: Tom <twburger_at_shaw.ca>
Date: 23 May 2006 11:21:47 -0700
Message-ID: <1148408507.333859.274480@y43g2000cwc.googlegroups.com>


I have done similar projects and have found that the simplest method to migrate data between platforms is to use a platform neutral data format (ASCII flat tables) for export and very carefully create a dictionary to control the import into the new system.

To access both systems at once using an application residing on one of the servers: First don't have the application on either server. Build a simple SQL interface that has drivers for both databases and have that running on a UNIX/Linux/W2K box on the network. With a DB selection system, data input and results viewing interface and a data export option, it should only take a week to build and test. I should be very fast if kept simple. This would depend on the validation you required. Received on Tue May 23 2006 - 13:21:47 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US