Re: Migrating real world complex schema from Oracle 9i
Posted by:
Setu Garg
Date: May 25, 2005 09:46PM
Hi all,
I have a database which uses lots of stored procedures for interfacing with the front end. However it is confidential.
Secondly, as I have already told, it consists of 2 schemas: one mailnly comprising of data and the other comprising of data, stored proceddures, views, triggers & indexes.
The latest version of MySQL Migration Toolkit worked fine with the schema comprising of data. But it failed at the reverse engineering step for the second schema.
Correct me if I am wrong: I do not think stored procedures migration is currently supported by the Migration Toolkit ?
There will be a problem in migrating stored procedures which use cursors as OUT parameter from oracle to MySQL as MySQL does not currently supports cursors as OUT parameters.
~Setu.
========================================
Setu Garg
InterraIT India Ltd.
SDF E - 14, NSEZ,
Noida, UP - 201305
India.
Tel +91 120 256 8037 Ext: 313
========================================
Subject
Written By
Posted
Re: Migrating real world complex schema from Oracle 9i
May 25, 2005 09:46PM
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.