Migrates data from MSSQL to Oracle database

This article explains how to using ESF Database Migration Toolkit to migrate data from MSSQL to Oracle database in 3 easy steps.

Requirements:
Windows XP or higher.
ESF Database Migration Toolkit download.
MSSQL Server 6.5 or higher.
Oracle 9i or higher.

Introduction:

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

  • Put the MSSQL server name(or instance name when using OS Authentication).
  • If using "Standard" method then put the server port (default is 1433, or 1284 for SQL Server 2005 Express), plus, you must offer an username and password.
  • Put the SQL Server database name(or press "Refresh" button to list all databases), you can select an exists database or input an new database name in "Database" field, this toolkit will create the new database automation in converting.
  • SQL Server

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

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

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

  • Select the tables which will be migrated.
    Select Tables&Views

  • Click "..." to setting the table options or re-map the table structure.
    Transform

4). In "Execution" Dialog

  • Click "Submit" to starting migration, this tookit will help you to migrate data from MSSQL to Oracle without intervention.
    Execute

5). Finished

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