Re: Sybase to MySQL

[Sergio Andres De La Cruz Rodriguez]

Hi James:

I would advise you to use our MySQL Migration Wizard. You can find it in recent MySQL Workbench versions. Please install the latest Workbench 6.0 beta and you will find it in the rightmost panel in the home screen under the name "Database Migration". Migrations from Sybase ASE are fully supported.

Given the size of your source table, you would have to check the option that generates a data copying script in the Data Transfer Setup page and uncheck the option for copying the data online. You would then have to run the generated script from the command line (after editing it to set the source and target rdbms passwords).

Here's a tutorial for migrating from Sybase SQL Anywhere to MySQL. The process is very similar for Sybase ASE: http://mysqlworkbench.org/2013/06/how-to-database-migration-from-sybase-sqlanywhere-using-mysql-workbench/

Also, as Edwin suggested above, I would advise you to use InnoDB for the target table instead of MyISAM.

Hope this helps.

Sergio A. de la Cruz Rodríguez
Software Developer
Oracle Corp.