0

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....

Dolis
  • 9
  • 5
  • MYSQL <> MARIADB – P.Salmon Jan 11 '23 at 10:47
  • Export your data from GuptaDB to CSV file then import it into MySQL. – Akina Jan 11 '23 at 10:58
  • but i can work with MySQL in MariaDB – Dolis Jan 11 '23 at 10:59
  • *but i can work with MySQL in MariaDB* No. You can work with MySQL in MySQL or with MariaDB in MariaDB only. – Akina Jan 11 '23 at 11:00
  • PS. On MySQL - remove foreign keys before importing if exists, you'd recreate them after. – Akina Jan 11 '23 at 11:01
  • mariadb started as a fork of mysql which shares many mysql features but it's not a drop in replacement. – P.Salmon Jan 11 '23 at 11:01
  • okay thank you. so what SQL script type do i need to work with mariadb if not MySQL? – Dolis Jan 11 '23 at 11:04
  • There are tons of ETL (extract-transform-load) tools out there that can connect to both databases and perform the migration. Also, you can check with various control totals if the migration was successful. – Shadow Jan 11 '23 at 12:12
  • do you have a good (and free) recommendation for such an ETL tool that would work with outdated gupta? – Dolis Jan 11 '23 at 12:16
  • Asking for and providing product recommendations are explicitly off topic here on SO. – Shadow Jan 11 '23 at 13:49
  • Firstly, the very popular Gupta database is **'SQLBase'** not 'BaseSQL'. Secondly, your opinion of 'outdated' Gupta is completely unfounded, of topic and you should keep your opinions to yourself - they are damaging , untrue, and potentially erode those many sites that do actually rely on the a very reliable and modern SQLBase. Thirdly, if you'd done proper research on SO, you'd see that you can happily ETL from SQLBase natively - see my answer below. p.s. for those who don't understand, you can learn about the 'real' SQLBase here: https://www.opentext.com/products/gupta-sqlbase – Steve Leighton Jan 11 '23 at 20:45

1 Answers1

0

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.

Steve Leighton
  • 790
  • 5
  • 15