Migration from Ingres 2.6 to Oracle 9i
Hi, someone has performed a migration from Ingres 2.6 to Oracle 9i? How do you do it?!
I'm trying to do it but I have many problems... I tried the Oracle Ingres Gateway, but it have too many restrictions (it doesn't migrate primary keys, indexes...) besides Oracle doesn't treat all the values like Ingres, i.e., the character ''(null string) Ingres accepts it like a valid value, although for Oracle ''(null string) is a NULL, that's a problem when you have a not nullable field and a null string value...
Finally I made a java tool, that performs the migration, so I can migrate the structure of the Database from Ingres to Oracle very well, but now the problem is the data transfer.
Should I use SqlLoader? With SqlLoader can I change values, i.e. substitute null strings by whites when a field is not null? But how I unload a file with all the data understandable for SqlLoader?!
What a mess!!!
Regards,