Migrating to MySql

General discussion forum about all databases other than SqlBase.
monchotgu
Honduras
Posts: 7
Joined: 24 Apr 2017, 02:55
Location: Honduras

Migrating to MySql

Post by monchotgu » 05 Jun 2017, 05:49

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
Austria
Posts: 5
Joined: 08 Mar 2017, 09:51
Location: Austria

Re: Migrating to MySql

Post by clemdoc » 07 Jun 2017, 09:12

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
Honduras
Posts: 7
Joined: 24 Apr 2017, 02:55
Location: Honduras

Re: Migrating to MySql

Post by monchotgu » 08 Jun 2017, 05:08

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.

Return to “General Discussion”

Who is online

Users browsing this forum: Ccbot [Crawler] and 0 guests