Data Loader — the Easiest Way to Convert Oracle to MSSQL or MS SQL Server to Oracle

Convert MS SQL Server to Oracle or Oracle to MSSQL in just a few mouse clicks. No need to write a single piece of code — Data Loader automatically converts tables, schemas, constraints, default values, and of course data.

It can also load data into existing tables with full column mapping support. Unlike other tools which just create and load data into new tables, Data Loader can load data into existing tables with different table names and column names.

It comes with its own scheduler to perform conversion jobs automatically at your specified intervals. Just create a session, define the execution date and time interval, and Data Loader automatically executes your session in the background and records the actions in a specified log file.

Key Capabilities

Support for Constraints and Indexes

Data Loader migrates constraints and indexes — including Primary Keys, Unique Keys, Foreign Keys, NOT NULL and Default values.

BULK INSERT and BULK LOAD

Supports BULK INSERT and BULK LOAD methods to load data into MS SQL Server and Oracle databases — greatly improving performance so millions of rows load in very little time.

UPSERT & INSERT

Synchronize data from any source database to any target database. UPSERT updates a matching row or inserts a new one; INSERT only inserts rows that don't already exist.

Full Editing

Edit or delete column mappings of saved sessions.

SQL Dump Files

Create SQL dump files from any source database — useful when you don't have a direct connection to the target Oracle or MS SQL Server database.

No Client Software Required

Supports all MS-SQL Server editions including Express Edition. Doesn't require Oracle Client software or ODBC drivers — Data Loader comes with Oracle client libraries built in.

Data Loader comes with its own built-in scheduler — no need to run jobs repeatedly. Just start a session, define the schedule date and time, and Data Loader automatically executes your session in the background and records the actions in a specified log file. You can check the log file for the result.

Data Loader uses a repository to store sessions. It provides options to create a new repository if the current one becomes damaged or lost, to take a backup, and to restore from a backup location.

You can manage existing sessions through the Manage Sessions form — view status, edit, run, delete, or view the log file of individual sessions.

Download Free Trial — Convert MSSQL to Oracle

Features

Wizard based
Fast speed
Completely user friendly
No need to write any code
Select single or multiple tables to transfer
Select or deselect columns while transferring
Change destination datatypes and widths
Automatic checking of datatype mismatch

Specify WHERE conditions to filter data
Filter columns and specify WHERE conditions when converting database to text
Rated best in category by many websites
Most popular product in the Database Apps section on download.com
Economical cost of just $99 for the Standard Version
Trial version available
Transfer millions of rows easily and fast
Supports LONG, LONG RAW, BLOB, CLOB, and picture datatypes