Oracle dump file is a binary format used to backup data. This format is not documented so there is no way to extract data from Oracle dump files except the standard IMP tool. However this tool only can import data to a working instance of Oracle server. But what if you just need access to the data without deploying Oracle database? Or may be you are going to migrate Oracle dump file into another data format? It is obvious that Oracle IMP or IMPDP tools cannot assist with those tasks.
Intelligent Converters, a software company specializing on different aspects of database migration since 2001, has investigated Oracle dump format and released the product to migrate it to the most popular data sources. This is OraDump Export Kit, software pack to convert Oracle dump files into Microsoft SQL, MySQL, PostgreSQL, Oracle, Microsoft Access, Microsoft Excel and CSV.
Key features of OraDump Export Kit:
- direct high performance reading dump files, Oracle components are not required
- complicated Oracle types such as XML and spatial are supported
- all versions of Oracle dump files generated by EXP or EXPDP tools are supported
- support for parallel export (multi-file) Oracle dump
- the product has no limitations on the dump file size
- support for encrypted Oracle dump files
Besides those primary features, OraDump Export Kit provides some other useful capabilities. It can store all conversion settings into profile to make easy next migrations of the same dump file. Also, the product allows to customize table structure by modifying name, type and other attributes of any column as well as excluding particular columns from migration. Finally, it can export the data from dump file into a local script file instead of moving to the target database. That script contains SQL statements to create all tables, constraints and to insert the data. This approach may be used to get more control over migration of Oracle dump file. Also, it can be a workaround for those cases where there is no direct connection to the destination database.
Still not sure OraDump Export Kit fits your needs? No problem, try free demo version with limited features. It allows to convert not more than fifty records for each database table and does not convert foreign keys. Test the capabilities of the demo and purchase full featured version if satisfied with the results.
As an extra advantage, OraDump Export Kit is supplied with subscription for updates that allows to receive new versions of the software tools included in the package for free within the subscription period. Visit the official site of Intelligent Converters to get more information about OraDump Export Kit.
