Re: Migrating real world complex schema from Oracle 9i
Posted by: Michael G. Zinner
Date: May 25, 2005 12:46PM

Michael,

any chances I could get my hands on the schema you are refering to? Best would be a SQL script to generate the schema on Oracle 9i. Then I could run the Migration Toolkit and fix the reverse engineering and datatype mapping issues quickly.

The data it's a different thing, but maybe you have some test data that is not confidential.

It is correct that there is no SQL J translator yet. But as the Migration Toolkit is very modular it would not be hard to add one. It depends on the functionality you use and if everything can be mapped to what MySQL 5 supports today.

Sequences are reverse engineered, but as we do not have any sequences in MySQL yet, they are not migrated - but could be used to generate AutoIncrement columns.

If possible, please contact me by email, mzinner at mysql dot com.

Thanks,
Mike

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

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

Options: ReplyQuote




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.