Hello,
I have written a utility in C# using ODBC.NET. It can fetch information
from an ODBC supported database table and copy it to the other ODBC
supported DB table; provided the tables exist on both databases with
similar schema.
This is running fine when I transder data from Oracle to DB2, MySQL to
Oracle and vice versa. But it fails from DB2 to Oracle.
I am using Datasets to retrieve data (using Select command of
OdbcCommand) from source DB and persist data in destination DB while
using CommandBuilder. So CommandBuilder generates INSERT command for me
automatically.
I retrieve data from DB2 and fill in a dataset, but when I try to
persist data in the destination DB, which is Oracle, the INSERT command
generated by CommandBuilder has qualified name for the table
(dbname.schemaname.tablename) and that qualified name is the problem
part. Is anybody aware, how can I avoid qualified name generated for
tablename? The same code works fine for vice versa scenario (when I
retieve data from Oracle and persist it in DB2) and does not generate
any qualified name for the table inside INSERT command.
Any help is greatly appreciated.
Rgds,
Ali