Hold it right there…
August 21st, 2006 — ddelmoliLooks like our MySQL migration work is on hold for now — the server is undergoing recovery. But in any event I think I’m going to abandon work with using ODBC through Oracle HS to Oracle XE conversion. In all, I think that approach would work for a light-weight system (i.e, systems between 1-3GB in database size, and without TEXT / LONG columns). But the MySQL database I’m looking at is about 80-100GB in size — small, but big enough (and including TEXT columns), that I’m probably going to move up to Oracle Migration Workbench andfull-blown Oracle 10g.
Now, if I can only scrounge up a stable test / development system…
August 23rd, 2006 at 12:32 am
Dominic
Isn’t XE limited to 4gb data anyway? Text/long/binary data is nearly always an issue for migrations in my experience.
cheers
Niall
August 23rd, 2006 at 8:24 am
Yep — 4GB limit. I’m curious to see how the Migration Workbench handles the text/long/clob data too.
March 6th, 2007 at 12:56 pm
Hi,
I have to migrate a MySQL DB to an Oracle XE DB. Did you managed to migrate your data using Oracle Migration Workbench ?
Do you think that using mysqldump can be a going way of achieving this ?
Thanks a lot for your help.
Regards,
Guillaume
March 12th, 2007 at 11:36 am
Depends on the size… I like the workbench for schema structure conversion. Not so much for data conversion. mysqldump and sqlloader work well too.