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.
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.
Who is online
Users browsing this forum: No registered users and 0 guests