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

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

• Data Types
• CREATE TABLE

Character data types:

Numeric data types:

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