Sybase ASE to MySQL Migration

SQLines tools can 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 SQL Converter - SQL Scripts Conversion and Assessment tool. Try Online
SQLines Data - Data Transfer, Schema Migration and Validation tool

Databases:

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

Migration Reference

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

SQLines SQL Converter

SQLines Data

Migration to MariaDB

Migration to MySQL

Migration to PostgreSQL

Migration to SQL Server

Migration to Oracle

Sybase ASE to MySQL Migration

Migration Reference

Data Types

CREATE TABLE Statement