LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   General (https://www.linuxquestions.org/questions/general-10/)
-   -   migrating a database is such a PITA (https://www.linuxquestions.org/questions/general-10/migrating-a-database-is-such-a-pita-666763/)

jiml8 08-31-2008 11:18 PM

migrating a database is such a PITA
 
I just thought I'd throw that in.

I just completed migrating a Superbase database to mysql. Only took 26 hours, and three programs (one in superbase to export all the tables as a modified csv, and two C++ programs - one to read and translate the superbase structure into mysql structure, and one to actually build the mysql import file) to handle the move. This was data and indexes only; no stored procedures were moved.

Next I intend to move it to MS SQL and probably to Oracle too. I do hope that those moves are easier since I have working mysql code.

pinniped 08-31-2008 11:40 PM

Couldn't Superbase export as a series of SQL commands? That would just leave you with the not-so-compatible bits to deal with.

Have fun. :)

jiml8 09-01-2008 12:15 AM

Superbase is supposed to export to one of a few different sqls, but I seem to not have the relevant dlls, and mysql (and for that matter MS sql) are not on the list.


All times are GMT -5. The time now is 08:22 PM.