Re: Oracle 8.1.7 to MySQL: problem with SP and sequences
Posted by: Michael G. Zinner
Date: August 18, 2005 08:59AM

Philip,

please download the following patch.

ftp://ftp.mysql.com/pub/mysql/download/mysql-migration-toolkit-patch1-1.0.13-rc-win32.zip

Place the two files in .\java\com\mysql\grt\modules overwriting the existing files. Then try again. All "unknown" or "strange" datatypes should now be converted to VARCHAR(255).

One other thing. After the reverse engineering please press F4. Browse the GRT Globals Tree down to /migration/sourceCatalog/schemata/YOUR_SCHEMA/tables/TABLE_WITH_NUMBER(100)/columns/COLUMN_WITH_NUMBER(100)

Then look at the object inspector below and please tell me the value of datatypeName, precision, scale and simpleType. You can also click on one value and select Copy All Values. It should be something like this.

39e706a46ad531be:-55ae50aa:105ca16696f:-7ff6-55ae50aa:105ca16696f:-7ff5
NUMBER
0
0
0
LIST
0
22
IDBLOBTEST
0
0
39e706a46ad531be:-55ae50aa:105ca16696f:-7ff8-55ae50aa:105ca16696f:-7ff7
22
0
{0DDAFF86-5345-4666-87CC-ECC3CB7EFFD7}
0

Mike

Michael Zinner, Team Lead, Developer Tools
MySQL AB, www.mysql.com

Are you MySQL certified? www.mysql.com/certification

Options: ReplyQuote


Subject
Written By
Posted
Re: Oracle 8.1.7 to MySQL: problem with SP and sequences
August 18, 2005 08:59AM


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.