Migrating data from MySQL to SQL Anywhere can be a straightforward process if there are not a lot of MySQL extensions in use within your database and application. SQL Anywhere simplifies migration by including built-in tools that facilitate a smooth transition from MySQL (and other RDBMS's) to SQL Anywhere.
The first part of this document discusses in detail differences between SQL Anywhere and MySQL, including data type differences, feature differences, and syntax differences. Some of the features are unique to MySQL and can hinder migration. Approaches for how you might choose to deal with these issues are provided. The second part of this document includes a systematic explanation of how to migrate data from a MySQL database into a SQL Anywhere database using the Sybase Central Data Migration wizard. Finally, the third part of this document supplies an example of how you might migrate an existing application running against MySQL to one that runs against SQL Anywhere.