Sybase SQL Anywhere to MySQL Migration

SQLines tools can help you transfer data, convert database schema (DDL), views, stored procedures, functions, triggers, queries and SQL scripts from SAP SQL Anywhere, Sybase SQL Anywhere, Sybase Adaptive Server Anywhere (Sybase ASA) to MySQL.

• SQLines SQL Converter - SQL Scripts Conversion and Assessment tool. Try Online
• SQLines Data - Data Transfer, Schema Migration and Validation tool

Databases:

• Sybase SQL Anywhere 17, 16, 12, 11, 10, 9 and 5
• MySQL 9.x, 8.x, 6.x and 5.x

See also Sybase Adaptive Server Enterprise to MySQL Migration.

• SQL Language Elements
• Data Types
• Built-in SQL Functions
• CREATE FUNCTION
• CREATE PROCEDURE
• CREATE TABLE

Converting SQL language elements and constructs:

	Sybase SQL Anywhere		MySQL
1	IF condition THEN exp ELSE exp2 ENDIF	IF expression	IF(condition, exp, exp2)

Character data types:

	Sybase SQL Anywhere		MySQL
1	CHAR(n)	Variable-length string, not padded, 1 ⇐ n ⇐ 32767	CHAR(n⇐255)	TEXT
2	LONG VARCHAR	Character data, ⇐ 2G	LONGTEXT

Unicode data:

	Sybase SQL Anywhere		MySQL
1	LONG NVARCHAR	Variable-length UTF-8 string, ⇐ 2G	LONGTEXT
2	NCHAR(n)	Fixed-length UTF-8 string, 1 ⇐ n ⇐ 32,767	NCHAR(n)
3	NVARCHAR(n)	Variable-length UTF-8 string, 1 ⇐ n ⇐ 32767	NVARCHAR(n)

Numeric data types:

Date and time data types:

Binary data:

Date and time functions:

System functions:

Converting user-defined SQL functions:

	Sybase SQL Anywhere	MySQL
1	CREATE FUNCTION name	CREATE FUNCTION name
2	(IN param type DEFAULT default, …)	(param type, …)	Default is not supported
3	RETURNS datatype(length)	RETURNS datatype(length)

Converting stored procedures:

	Sybase SQL Anywhere	MySQL
1	CREATE [OR REPLACE] PROCEDURE name	CREATE PROCEDURE name
2	(IN | OUT | INOUT param type DEFAULT default, …)	(IN | OUT | INOUT param type, …)	Default is not supported

Converting table definitions:

Data type attributes:

Constraints:

Foreign keys:

	Sybase SQL Anywhere		MySQL
1	NOT NULL FOREIGN KEY	NULLs are not allowed	FOREIGN KEY	NOT NULL clause commented
2	FOREIGN KEY (col ASC | DESC, …)	Column ordering	Not supported for foreign keys, removed