Oracle to MSSQL Converter  is a tool to Convert, Migrate data from Oracle Database to MS SQL Server Database or from MS SQL Server to Oracle Database. You can convert multiple tables in one go from Oracle to MSSQL or from MSSQL to Oracle. While migrating you can do Source & Target table column mapping in case, the tables columns order are not same. You can convert all rows or some rows by mentioning conditions.

Oracle to MSSQL Converter (previously known as Oracle to MSSQL Loader) comes with a built in scheduler so that you can run transfer jobs at specified intervals. Now no need to run jobs repeatedly, just create a session define the schedule date and time and Oracle to MSSQL Converter  will automatically executes your session in the background and records the actions in a specified log file. You can later on check the log file for information.

Provides a command line interface also to run migration jobs manually so that it can be easily integrated with your own application.
All the sessions are stored in a repository. Oracle to MSSQL Converter  provides a user friendly interface to manage repository. Such as taking backup and/or restore repository from a previous backup. You can also create a new blank repository in case you need it.

Using Oracle to MSSQL Converter  you can perform the following conversion

• ORACLE to MS SQL Server Database
• ORACLE to MSSQL SQL Dump file
• MS SQL Server to ORACLE Database
• MS SQL Server to ORACLE SQL Dump file
• ORACLE to ORACLE SQL Dump file
• ORACLE to ORACLE Database
• MS SQL Server to MS SQL Server Database
• MS SQL Server to MSSQL SQL Dump file

UPSERT and INSERT loading options

Synchronizes Oracle and MS SQL Server tables by Updating a row if a matching row exist in the  target table. If the matching row does not exist it Inserts a new row in the target table. Beside UPSERT and INSERT option, Oracle to MSSQL Converter also supports APPEND, DELETE, DROP loading options.

Features

• Uses Bulk Loading to load tables with million of rows at blazing speeds
• Supports UPSERT and INSERT loading options.
• Imports Constraints and Indexes
• Wizard based
• Map Source Columns to Target Table columns
• Specify WHERE conditions to filter data
• Save and Schedule of Sessions for recurring data transfers.
• Fast Speed
• Completely user friendly
• No need to write any code
• Repository Database is introduced. 
• Select single or multiple tables to transfer
• Check or Uncheck Columns while transferring
• Change Target table Datatypes and Sizes
• Automatic Checks Mismatch between source and target table columns datatypes.
• Rated Best in the category by many websites
• Most Popular product in Database App. section in download.com
• Economical costs just $99 For Standard Version
• Fully functional Trial version with just 50 rows limit is available
• Transfer Millions of rows easily and fast. That’s what our existing Customers are doing
• Supports Long , Picture Data types. In a jiffy you can copy data without any coding
• Supported O/s: Win 10, Win 8.1, Win 7,Win 2000, XP