Oracle Migration
Posted by: Andrew Gilfrin
Date: June 17, 2005 04:10PM

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

Options: ReplyQuote


Subject
Written By
Posted
Oracle Migration
June 17, 2005 04:10PM
June 17, 2005 05:08PM
June 17, 2005 05:22PM
June 18, 2005 11:35PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.