Hiya
I have a database file in Dynamics NAV 5.0 native format - about 200-300 tables totalling maybe 10 GB worth of data.
My task is to migrate those tables with their data into a schema in our Oracle 11.2 database.
No tools support the NAV format directly :-) But I have a windows ODBC driver for that format that works.
The Oracle database runs on Linux and I have no ODBC transparent gateway and no linux ODBC driver that would let me access the NAV datafile directly from within Oracle.
I tried migration wizard in SQL Developer, but it seems it cannot use a "generic ODBC" datasource (even with JDBC-ODBC bridge), it must be a supported database format?
Then I have tried trial of product Altova MapForce, but it can't seem to read the schema (table/columns) from the ODBC datasource for some reason.
I know reading the schema from the ODBC datasource is possible - I have used third party product "Database Browser" that reads the ODBC with no problems.
And a colleague has read the schema of the ODBC in C# also.
I am primarily a SQL developer. My colleague said he could write in C# a program that looped over the tables in the ODBC, read the columns, executed "create table" in Oracle, read data from the ODBC, inserted data in Oracle.
But he is going on vacation right now :-( And I keep thinking that someone else must have written such a migration program ;-)
I just can't seem to find it by googling? Altova Mapforce was my best bet, but it just seems to have problems with this specific ODBC datasource.
Any ideas for a migration tool that can accept a generic ODBC datasource and not specifically SQL Server, MySQL, DB2, etc.?
Thanks for any hints that might help ;-)
Regards
Kim Berg Hansen