I hope you can help me:
I'm working on a project, which has the goal to migration from an old legacy application (using an informix db) to a complete new application (using an oracle db).
1.) I'm now looking for oracle tools where I can test the db-content of one informix-db (source) with the content of the oracle db (target). The migration strategy is now that the two applications run in pararell and we will compare the content of the db's regulary and it would be create if we can script this. (so it runs automatically).
Do you have any recommandations which oracle product could support that? I have also read about the Oracle® Migration Workbench, but for me it seems that it is not build to compare the datacontent, it is more a tool to create a completely new source db from informix data to oracledata.
2.) For the new system it is planned to have a great new test system as well. So I also would like to compare data in one Oracle instance (test-instance) with the production environment. (also Oracle db.) (Because there are running some sensible scripts, which always HAVE to produce the same output.)
Do you have any recommendation for that as well?
Regarding Oracle - Oracle distribution and verification I would recommend to use GoldenGate and Veridata Oracle GoldenGate</title><meta name="Title" content="Oracle GoldenGate"><meta name=&q…
Unfortunately GG does not support Informix directly - but maybe using JDBC adapter works.
Best would be to post your issue in their community: GoldenGate
SQLines Data tool can migrate and validate data when you migrate from Informix to Oracle. You can easily compare row count as well as content. The tool orders rows by primary or unique keys/indexes, or if they are not available by all columns (except LOBs).