how to migrate a gupta (SQLBase) database to MySQL (including data)

Question

Im trying to migrate a Gupta DB to MySQL. I already have a script to create every Table (with indexes and comments) and views I need in MySQL (table-, view- and column-names as well as column-types are equal in gupta as well as MySQL). But now I cant figure out how to read data from the old SQLBase Database and "import it" into the new MySQL database.

i thought of reading the old data from SQLBase and writing it in a file to then read it somehow via MySQL to import it. the Problem here is that for some tables there are more than 1 million records which i can not lose a single one of....

Answer 1

You can ETL natively from Gupta 'SQLBase' very easily. But you need to read the manual appropriate for your SQLBase version here: Gupta SQLBase manuals ( all verions ) , specifically, you need to read the 'UNLOAD' command in the 'Language Reference' manual. But best advice is: Don't do it ! Upgrade to SQLBase v12.2 instead.

Answer 2

We also use SQLBase in various versions, including 12.2. We too are considering a switch to MySQL, MariaDB, or Microsoft SQL Server. We're quite bothered by the fact that SQLBase still doesn't offer Entity Framework support. This means that one has to either directly access the database via Team Developer or use ADO.NET when programming in C#.

The issue is that we have a significant amount of code in Team Developer 7.5, so we can't simply swap out the database. Specifically, we no longer want to develop using ADO.NET but with Entity Framework instead.

What needs to be done so we can use a different database like MySQL, MariaDB, Postgre, or MS SQL Server with Team Developer 7.5? This way, we could finally access the database from .NET using Entity Framework, while still leveraging the existing Team Developer code.