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!
OraMigrator is an intuitive and effective solution for Oracle to SQL Server data migration. The tool transfers data from Oracle tables to existing SQL Server tables in a few easy steps.
Free trial version of OraMigrator can be used for evaluation purposes during two days after the downloading. Also, it migrates 10% of rows per each table, but not less than 100 rows. To enjoy the full functionality of this product for an unlimited period of time, you need to 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.
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 it 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.
OraMigrator requires the following software to be installed on your computer:
Windows Server 2003 or higher; Windows XP or higher
Microsoft .NET Framework 2.0
Oracle client 8.1.7 or later with Windows connectivity tools (Oracle Data Provider for .NET and/or Oracle OLE DB Provider)
You are downloading a free trial version of OraMigrator. Keep in mind that with the trial version you can migrate 10% of rows per each table, but not less than 100 rows. Please purchase the license key to upgrade to the full version.