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.