SQLines Data Tool - MySQL to Oracle Database Migration

SQLines Data is a scalable, high performance data transfer, schema conversion and validation tool for MySQL to Oracle migration.

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

MySQL 5.x and 4.x
Oracle 12c, 11g, 10g and 9i

Why SQLines Data

SQLines Data benefits:

Advanced Schema Conversion and Data Transformation

Converting identifiers exceeding 30 characters
Replacing zero DATE '0000-00-00' and DATETIME '0000-00-00 00:00:00' with NULL values

Migration Validation

Comparing column data in each row taking into account data transformations
Comparing the number of rows in MySQL and Oracle tables

Scalability and High-Performance

Transferring data in multiple concurrent sessions
Performing concurrent read and write operations in each session
Using MySQL C API to extract data from MySQL
Using Oracle OCI with array processing to load data to Oracle
Multithreaded C/C++ application

Designed for DBAs and Enterprise-Class Migrations

Easy to set up and configure the transfer of a large number of tables
Command line with powerful and easy to use options
Wildcards to select tables
Comprehensive performance stats to help you tune the data transfer
No space required to hold MySQL export
No ADO.NET providers required
No .NET dependency

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 MySQL to Oracle Migration
Schema Conversion
CREATE TABLE Statement
NOT NULL Constraints
Schema Transformation
Schema Name Mapping
Reserved Words
Validation
Validation by Row Count
Full Data Validation
Performance and Scalability
Parallel Sessions	Unlimited
Concurrent Reader/Writer in Each Session
32-bit Version
Automation
Command Line
Licensing and Support
Technical Support