OraDump to MSSQL Features:

• All versions of Oracle dump files are supported (both EXP and EXPDP).
• Encrypted dump files are supported.
• All versions of MS SQL servers are supported.
• Oracle installation IS NOT required.
• Converts parallel export Oracle dump files.
• Converts indexes with all necessary attributes.
• Converts foreign keys.
• Option to customize types mapping, select certain columns to convert.
• Option to convert individual tables.
• Option to export data into T-SQL script file.
• Option to merge Oracle data into an existing MS SQL database.
• Stores conversion settings into profile.
• Command line support.
• Quick Launch.
• Easy-to-use wizard-style interface.
• Full install/uninstall support.
• The product can be customized according to customer requirements.
• Unlimited 24/7 support service.
• 1-year subscription for updates.

Limitations

• Does not support compressed dump files.
• Does not convert views, stored procedures and triggers.
• Does not convert columns having user-defined types.
• Demo version converts only 50 records per table.

Export into T-SQL script file

It is not always possible to have direct access to Microsoft SQL server. For these cases, OraDump-to-MSSQL converter allows users to do indirect conversion and get more control over the process. Following this process, the program exports Oracle dump data into a local T-SQL script file instead of moving it to MS SQL server directly. This file contains SQL statements to create all tables and fill them with the data.