Sybase IQ to oracle load data

When I have a huge migration like this, I opt to extract the data into flat files, then import into the new database, then extract again from the new database into a new set of flat files, and compare the flat files.

This is called "round tripping", and the advantage is it does not tax the database for comparison.

As long as you order the columns the same, theoretically in the end, you should have identical flat files that you can use command line utilities / diff utilities to compare. And theoretically, a checksum of the file should match.

Use bcp to extract from Sybase, and sqlloader to import to from Oracle. Then use PL/SQL to export from Oracle again.

1.Oracle has ability to connect a Sybase IQ 15 database?
2.What compare tools it's recommended for huge files?

>>1.Oracle has ability to connect a Sybase IQ 15 database?

Yes, either via the ODBC connector or a specific connector, which is possible additional $$.
But I wasn't recommending a connector, I recommend doing it without a connector, given the requirement for comparison / auditing.


>>2.What compare tools it's recommended for huge files?

Which OS are you using?

For UNIX I've used md5sum for checksum, and the other command line utils: diff, uniq

If there is binary data, it might be a bit more complicated.

They are text files. The OS it's Windows Server 2003 R2.
I want to give a chance to ODBC connector for Sybase IQ.
My idea is following:
-import data to oracle 11g from Sybase IQ via an ODBC connection
2. I want to know it it's the possibility in Oracle to connect to a Sybase IQ table
and to write following code for example:

select o.c1,s.c1,o.c2,s.c2 
from oracle_table o inner join sybase_remote_table  s
on o.c1=s.c1
where o.c2!=s.c2 

Select allOpen in new window

to view import errors.

Oracle gateway pack permits the connection to Sybase IQ?

Why don't you download the pack and look into the docs and see?

thanks for suggestions.

No need to close question so soon, you may get other answers. Good luck.