Migrating from Microsoft SQL Server to Oracle

This document describes how to quickly migrate from Microsoft SQL Server to Oracle in 3 easy steps using ESF Database Migration Toolkit.


  • Windows XP or higher.
  • ESF Database Migration Toolkit download.
  • Microsoft SQL Server 6.5 or higher.
  • Oracle 9i or higher.


1. In "Choose a Data Source" dialog, choose "Microsoft SQL Server (Standard)" or "Microsoft SQL Server (OS Authentication)";

  • Input the SQL Server host name(or instance name when using OS Authentication).
  • If using "Standard" method then input the server port (default is 1433, or 1284 for SQL Server 2005 Express), plus, you must offer an username and password.
  • Input the SQL Server database name(or press "Refresh" button to list all databases), you can select a database in "Database" combobox.
  • SQL Server

2. In "Choose a Destination" dialog, choose "Oracle";

  • Input the server name(default: localhost) and port(default: 1521).
  • Input the username(default is "system") and its password.
  • Select the logon method(SID, Service_Name or TNS).
  • Input the source Oracle SID or Service_Name in "Database" box or let it empty if using TNS method.
  • Input the schema name or let it empty(default is same as username, you can press "Refresh" button to list all schemas).

3. In "Select source Tables(s) & View(s)" dialog

  • Select the tables/views that will be migrated.
    Select Tables&Views

  • Click "..." to set the table options or remap the table structure.

4. In "Execution" Dialog;

  • Click "Submit" to begin the migration, this tookit will help you quickly migrate data from Microsoft SQL Server to Oracle without intervention.

5. Finished!

If you have any questions or suggestions, please contact us. Thank you for your time!

Download Now! »