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