OraMigrator

Overview

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

Features

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

• 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.

Watch the screencast

How to use the tool

Execute the DataCompareSuite.msi file after it has been downloaded. During the installation, you should specify the folder for the program files.

Screenshots