MySQL Forums
Forum List  »  Sybase

Re: Sybase to MySQL
Posted by: Sergio Andres De La Cruz Rodriguez
Date: July 08, 2013 01:13PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
1807
July 08, 2013 08:43AM
765
July 08, 2013 11:49AM
701
July 08, 2013 12:27PM
848
July 12, 2013 04:16AM
Re: Sybase to MySQL
822
July 08, 2013 01:13PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.