SQLines Data Tool - Database Migration from Sybase ASE to MySQL

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

The tool requires connections to Sybase (CT-Lib) and MySQL (MySQL C API) databases. To convert standalone SQL statements and SQL scripts, use SQLines SQL Converter tool.

  • Sybase ASE 16.x, 15.x, 12.x
  • MySQL 8.x and 5.x

Why SQLines Data

SQLines Data benefits:

Migration Features

  • All Data Types
  • NOT NULL Constraints
  • DEFAULT Clauses
  • CHECK Constraints
  • Primary and Foreign Keys
  • Unique Constraints
  • Indexes
  • Comments on Tables and Columns
  • Schema Name Mapping
  • Validation by Row Count

You can use SQLines SQL Converter tool to convert stored procedures, functions, triggers, views and other objects.

Migration Validation

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

Scalability and High-Performance

  • Transferring and validating tables in multiple concurrent sessions
  • Performing concurrent read and write operations in each session
  • Using Sybase Client Library/C (CT-Lib) with array processing to extract data from Sybase
  • Using MySQL C API with LOAD DATA INFILE command to load data to MySQL
  • Direct in-memory data transfer, no disk space required for export
  • Multi-threaded C/C++ application
  • Linux and Windows, 32-bit and 64-bit

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 Oracle export
  • No ODBC drivers 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 chat