Home » Open Source » MySQL » MYSQL TO ORACLE MIGRATION---Stored procedures (MYSQL 5.0 to ORACLE 10G or 11G)
MYSQL TO ORACLE MIGRATION---Stored procedures [message #505855] Thu, 05 May 2011 05:23 Go to next message
Vinay_s07
Messages: 8
Registered: March 2011
Location: Bangalore
Junior Member
Hello,

Could you please provide me any information related to stored procedures migration from MYSQL to ORACLE plaese?

I have managed to migrate the database structures, data, Indexes, and constraints from MYSQL to ORACLE using oracle sql developer tool. But getting errors while migrating the views and stored procedures.

Error received:Migration actions have failed:check the migration reports for details:ORA-00902:Invalid data type.

Any help or information on this would be much appreciated.

Thanks and Regards.

Vinay B S
Re: MYSQL TO ORACLE MIGRATION---Stored procedures [message #505856 is a reply to message #505855] Thu, 05 May 2011 05:32 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Have you checked the migration reports for details yet?
Re: MYSQL TO ORACLE MIGRATION---Stored procedures [message #505857 is a reply to message #505856] Thu, 05 May 2011 05:35 Go to previous messageGo to next message
Vinay_s07
Messages: 8
Registered: March 2011
Location: Bangalore
Junior Member
Tanks for your response.

No. I have not checked migration reports. I have no idea about where the reports are stored. Oracle sql developer is not providing enough information about the errors.

Thank you.
Re: MYSQL TO ORACLE MIGRATION---Stored procedures [message #505859 is a reply to message #505857] Thu, 05 May 2011 05:53 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Well it should be somewhere in this window.

It might also be worthwhile to have a look at the actual procedure that was created in the oracle database, and have a look what compilation errors it has.
Re: MYSQL TO ORACLE MIGRATION---Stored procedures [message #505860 is a reply to message #505859] Thu, 05 May 2011 05:59 Go to previous messageGo to next message
Vinay_s07
Messages: 8
Registered: March 2011
Location: Bangalore
Junior Member
Hi,

I am unable to access the link from the office (blocked). Could you please give me an hint from where can i see the report in the SQL developer or else i will check it from home tomorrow.

Thanks and Regards.

Vinay B S
Re: MYSQL TO ORACLE MIGRATION---Stored procedures [message #505863 is a reply to message #505860] Thu, 05 May 2011 06:07 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Well they should be listed in the Reports navigator: "click Migration Reports" according to the handbook here. (I hope you can access oracle.com)

Another option would be to take the DDL scripts that were created, and run them one by one in the query window to see where exactly the error is.
Re: MYSQL TO ORACLE MIGRATION---Stored procedures [message #505872 is a reply to message #505860] Thu, 05 May 2011 06:38 Go to previous messageGo to next message
Vinay_s07
Messages: 8
Registered: March 2011
Location: Bangalore
Junior Member
Hi,

I am unable find the Migration reports in Reports navigator.

Thanks and Regards.

Vinay B S
Re: MYSQL TO ORACLE MIGRATION---Stored procedures [message #505874 is a reply to message #505872] Thu, 05 May 2011 06:45 Go to previous messageGo to next message
Vinay_s07
Messages: 8
Registered: March 2011
Location: Bangalore
Junior Member
Hello,

DDL scripts will be generated only for the captured objects which are converted successfully. In my case procedures and views are not gettting converted hence there is no DDL scripts generated for procedures and views.

Thanks adn Regards.

Vinay B S
Re: MYSQL TO ORACLE MIGRATION---Stored procedures [message #505876 is a reply to message #505863] Thu, 05 May 2011 07:11 Go to previous messageGo to next message
Vinay_s07
Messages: 8
Registered: March 2011
Location: Bangalore
Junior Member
Hi,

I am unable to find the Migration reports in Reports navigator.

DDL scripts will be generated only for the captured objects which have been converted successfully. In my case procedures and views are not gettting converted hence there is no DDL scripts generated for procedures and views.

Can you also confirm whether the oracle sql developer supports the converision of MYSQL view's and stored procedures to oracle databse please? Reason being asking this question is that all the objects including procedures and views are being captured properly and but conversion is happening only for the tables, indexes and constraints.

Data movement is also happening perfectly.

Thanks adn Regards.

Vinay B S

Re: MYSQL TO ORACLE MIGRATION---Stored procedures [message #505877 is a reply to message #505876] Thu, 05 May 2011 07:30 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Well, I have never used that automated conversion myself, so I can't really confirm how good it works.
Re: MYSQL TO ORACLE MIGRATION---Stored procedures [message #505878 is a reply to message #505877] Thu, 05 May 2011 07:32 Go to previous messageGo to next message
Vinay_s07
Messages: 8
Registered: March 2011
Location: Bangalore
Junior Member
Ok. Do you have any other suggestions or options?
Re: MYSQL TO ORACLE MIGRATION---Stored procedures [message #505880 is a reply to message #505878] Thu, 05 May 2011 07:48 Go to previous message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Only the old fashioned way: have a look what the procedures do, and re-write what needs to be done in PL/SQL.

Since procedures in MySQL and procedures in Oracle can do different things using different syntax it's hard to say how complicated that will be. Depends on what features the procedures rely on.
Previous Topic: Alter table from different databases
Next Topic: MYSQL Dead lock issues
Goto Forum:
  


Current Time: Tue Mar 19 05:03:56 CDT 2024