This is an old revision of the document!
SQLines Data is an open source (Apache License 2.0), scalable, parallel high performance data transfer and schema conversion tool that you can use for database migrations and ETL processes.
SQLines Data is written in C/C++ and uses native low-level in-memory bulk loader APIs to transfer data. It is available for Linux, Windows, both 64-bit and 32-bit platforms.
SQLines Data guides for specific database migrations:
MariaDB | Oracle | SQL Server | MySQL |
Oracle to MariaDB | IBM DB2 to Oracle | Oracle to SQL Server | Oracle to MySQL |
SQL Server to MariaDB | Sybase ASE to Oracle | ||
Sybase ASE to MariaDB |
You can use SQLines Data for cross-platform database migration. The tool migrates table definitions, constraints, indexes and transfers data.
Migration Features:
You can use SQLines Data in your ETL processes as a data extact-load tool.
ETL Features:
Sometime you do not need to move constraints and indexes into the target database. For example, in case when you move data for reporting purpose, or if you want to migrate constraints and indexes later.
Edit sqldata.cfg configuration file, and set -constraints=no and -indexes=no.