Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Interbase / Oracle Communication
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