SQLines Data Tool - Database Migration from SQL Server to Oracle

SQLData is a scalable, high performance data transfer, schema conversion and validation tool for Microsoft SQL Server to Oracle migration.

The tool requires connections to SQL Server (SQL Server Native Client API) and Oracle (OCI) databases. To convert SQL statements and scripts, use SQLines SQL Converter tool.

Why SQLines Data

SQLines Data benefits:

Scalability and High-Performance

  • Transferring tables in multiple concurrent sessions
  • Performing concurrent read and write operations in each session
  • Using SQL Server Native Client with array processing to extract data from SQL Server
  • Using Oracle OCI with array processing to load data to Oracle
  • Multi-threaded C/C++ application

Migration Validation

  • Comparing the number of rows in Oracle and SQL Server tables

Designed for DBAs and Enterprise-Class Migrations

  • Easy to set up and configure the transfer of a large number of tables
  • Wildcards to select and exclude tables
  • Comprehensive performance stats to help you tune the data transfer
  • No space required to hold SQL Server export
  • No Oracle ODBC driver and ADO.NET providers required
  • No .NET dependency
  • No installation required

Logging and Statistics

  • Comprehensive performance stats to help you tune the data transfer
  • Execution time for each DDL statement
  • Read and write performance for each table (rows/sec and bytes/sec)
  • Saving all executed DDL SQL statements into .sql file
  • Saving all failed DDL SQL statements into a separate .sql file
  • Summary performance information

Technical Support and Custom Solutions

  • Direct support from the development team and migration experts
  • Immediate software fixes and updates
  • Custom features by request
  • Email, phone and Skype

SQLines Data Features and Licensing

SQLines Data features and licensing:

SQLines Data for SQL Server to Oracle Migration
Database Size
Data Volume Unlimited
Number of Tables
Number of Rows
Number of Databases
Schema Conversion
CREATE TABLE Statement
NOT NULL Constraints
DEFAULT Clauses
CHECK Constraints
Primary and Foreign Keys
Unique Constraints
Indexes
Table and Column Comments
Sequences
Schema Transformation
Schema Name Mapping
Validation
Validation by Row Count
Performance and Scalability
Parallel Sessions Unlimited
Concurrent Reader/Writer in Each Session
32-bit Version
Automation
Command Line
Licensing and Support
Technical Support

Download a Trial Version of SQLines Data.

If any you have any questions or need any assistance, please contact us at support@sqlines.com.

SQL Conversion Features

For detailed information about conversion features supported in SQLines Data, see SQL Server to Oracle Migration Reference.