Hi Folks,
I need to convert some data from INGRES to ORACLE. Is there any tool for that.
Printable View
Hi Folks,
I need to convert some data from INGRES to ORACLE. Is there any tool for that.
only data or whole database structure+constraints+indexes
Pando,
All ready we have database in oracle. Now some other dept people wants to use the same application. I created a new database for them but now they are asking me to migrate data from INGRES to ORACLE. I asked them to send data in text files, After that i will load the data in temp tables and i will do some modifications to that data and i will load that data into production tables. Do you know any tools to help this process?
reverse engineering the data model in ingress (with ER Studio by Embarcadero and with ODBC if ingress supports ODBC?), generate a Oracle SQL script to create the tables, ER Studio will generate script to create the tables, indexes, and constraints.
Get the data in plain txt file and load it to the tables
with SQL*Loader