This is an old revision of the document!
SQLines Data is an open source, scalable, high performance data transfer, schema conversion and validation tool for Oracle to MySQL migration.
The tool requires connections to Oracle (OCI) and MySQL (MySQL C API) databases. To convert standalone SQL statements and SQL scripts, use SQLines SQL Converter tool.
SQLines Data benefits:
Migration Features
You can use SQLines SQL Converter tool to convert stored procedures, functions, triggers, views and other objects.
Advanced Database Schema Conversion and Data Transfer Features
Migration Validation
Scalability and High-Performance
Designed for DBAs and Enterprise-Class Migrations
Logging and Statistics
Technical Support and Custom Solutions
There are two main sources that can help you troubleshoot SQLines Data:
sqldata.log file contains the detailed information about MySQL to Oracle migration process.
By default, sqldata.log file is located in the current working directory. You can use -log command line option to change its location and file name.
sqldata_ddl.sql file contains information about all DDL statements executed in MySQL during migration.
In this file you can see the full SQL statements, the execution result (success or failure) and the execution time. In case of an error, you can find the error message returned by MySQL.
By default, sqldata_ddl.sql file is located in the current working directory. You can use -out command line option to change its location.
If there are any failed SQL statements, you can find them in sqldata_failed.sql file.