Sybase ASE to MySQL Migration

SQLines provides services and tools to help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from Sybase Adaptive Server Enterprise (Sybase ASE) to MySQL.

  • SQLines Data - Schema, data migration and validation tool
  • SQLines SQL Converter - SQL scripts conversion tool

Databases:

  • Sybase Adaptive Server Enterprise 16.x, 15.x, 12.x and 11.x
  • MySQL 8.x, 6.x, 5.x

Migration Reference

Technical information on migration from Sybase Adaptive Server Enterprise (Sybase ASE) to MySQL:

Data Types

Character data types:

Sybase ASE MySQL
1 CHAR Fixed-length character string CHAR
2 VARCHAR Variable-length character string VARCHAR

Numeric data types:

Sybase ASE MySQL
1 INT, INTEGER 32-bit integer INT, INTEGER
2 NUMERIC, NUMERIC(p), NUMERIC(p, 0) Integer, 1 <= p <= 38, default is 18 INTEGER p < 9
BIGINT p >= 9
3 SMALLINT 16-bit integer SMALLINT

CREATE TABLE Statement

Converting CREATE TABLE statement keywords and clauses:

Sybase ASE MySQL
1 IDENTITY(start, increment) Identity column AUTO_INCREMENT Increment is always 1
2 IDENTITY can be defined on DECIMAL/NUMERIC columns Integer columns must be used