Dear guest !

Welcome to Team Developer Community Forum. A place created by the community, for the community !

This is a resource for Q & A and discussion about everything related to OpenText Gupta Team Developer, SqlBase, TD Mobile and Report Builder.
It is the alternative for the OpenText customer forums which can only be accessed with an active support contract.

Please register your account now. It will make you part of the active community.
Also, this guest message will not be displayed for registered users.

As a bonus, registered users have access to the 'Newsgroups' subforum, holding 10 years worth of posts from the good old Gupta newsgroups.

Having an account gives you the opportunity to ask questions and get help from others.
We hope this free gathering will help you and the community getting forward!

Best regards,
The forum site admins.

Migrating to MySql

General discussion forum about all databases other than SqlBase.
Post Reply
monchotgu
Honduras
Posts: 6
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: 2
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: 6
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.

Post Reply

Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 1 guest