I've been testing the Migration tool against Oracle....
Oracle has a test/demo schema called HR which has a small amout of tables and data and makes and idea starting point to test.
It has the following, 7 tables, 1 View, 2 Stored Procedures and 3 sequences.
I decided to just test the tables. I did the migration and it seemed to work fine but when I logged into MySQL I noticed that only 4 of the 7 tables had been migrated.
The 4 that transfered seem to have been created and the correct amount of data is shown. One problem I did see is that in Oracle it's using a NUMBER type and this is converted to INT in MySQL I don't think this should be the case.
In Oracle any numbers which are defined without a size are by default (13,2) the migration tool kit seems to have assumed it's an INT which is not correct.
I deleted the MySQL DB and tried again but the same thing happened 4 tables only.
Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog
http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information