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!
The forum site admins.
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 1 guest