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