OraMigrator^™

Try 2-day free fully functional trial version
of OraMigrator

Looking for a safe way to migrate your data from Oracle to SQL Server?

This simple, but very powerful tool is exactly what you need!

Overview

OraMigrator is a simple but effective solution for Oracle to SQL Server 2008/2012 data migration. The tool transfers data from Oracle tables to existing SQL Server tables in a few easy steps.

Attention

Free trial version of OraMigrator can be used for evaluation purposes during 2 days after the downloading. Also, it migrates 10% of rows per each table, but not less than 100 rows. To enjoy full functionality of this product for unlimited period of time, you must buy a license.

How to use the tool

Execute the OraMigratorSetup.msi file after it has been downloaded. During the installation, you should specify the folder for the program files and choose features to be installed. If you check “Launch OraMigrator when setup exits” during the installation, OraMigrator wizard will invite you to start the migration!

Paul S., IT Manager

This tool has automated the migration, saving us from having to do hours and hours of manual coding.

Features

A wizard-like interface that allows restarting migration from any step;

The tool uses the bulk copy mechanism to load data from Oracle tables to SQL Server. This approach allows to achieve the maximum possible insertion speed;

Current migration task can be saved in a file and restored later. Thus you don't need to specify all parameters from scratch when you are repeating the migration for a similar set of tables on the same servers;

The SELECT statement which reads the source data can be edited. This allows fixing many common data migration problems like incompatibilities in date ranges and number precision. Also, it makes possible to perform a partial data migration, when you need to move only the records modified after a particular moment of time;

Many tables can be migrated as a part of a single migration task. The target SQL Server database and schema can be specified only once for the whole task;

A SQL Server table can have column names different from Oracle. This can occur, for example, when an Oracle column name happens to be a SQL Server keyword. OraMigrator has a Column Mapping feature, which allows establishing a custom correspondence between Oracle and SQL Server columns if necessary.