Migrating to MySql

[monchotgu]

A customer that has a old Sqlbase6.1 database wants to migrate to MySql database. Has anyBody done this. Do you know of any tools available to do this type of migration?

Thanks in advance

[clemdoc]

Do you want to just copy the data or migrate a complete application?

If you're just asking about copying the data from an SqlBase to a MySql DB: It's fairly easy to write a program in C# that will do this for you. Just get the necessary information from SYSTABLES, SYSCOLUMNS, SYSINDEXES, SYSKEYS and the like, read the data from SqlBase, generate the necessary CREATE TABLE statements for MySql and insert the data into MySql. A DataTable should be helpful here, otherwise you can write your own classes to store the information.
You'll need a .Net driver to connect to SqlBase. I've been using the driver from SqlBase 12 to connect to a SqlBase 11.5 and that worked without any problems. I don't know for SqlBase 6.1, YMMV.
I'm sorry I cannot share the code though.

If you're (also) asking about migrating your application: That will be an entirely different beast, as you'll basically need to check every SQL statement whether it's correct for MySql. Depending on the size of your application and the development environment (Team Developer?), that might be quite a challenging task.

HTH, Clemens

[monchotgu]

Thanks for the advice.

Both Option are being considered. I know migrating the applicacion is a big endevour. Especially since we use Team Developer 3.1 and apparently there is a problem with saving dates in the format from ctd. The dates have to be transform to string.