Re: how to migrate oracle stored procedures to mysql
Posted by:
Ben Krug
Date: December 12, 2007 11:36PM
Fatma - does the documentation say the toolkit will convert stored procedures? I only see where it says it will convert schemas and data.
PL/SQL syntax is non-standard and very particular to Oracle (which Oracle is proud of), so it does not transfer easily to other databases. Tom of "Ask Tom" discusses this in his Oracle books, where he talks about portability and lacks of portability.
I may be wrong, but I think the procedures will have to be gone through and re-written as MySQL stored procedures or other code. I hope someone will correct me if I'm wrong.
Subject
Views
Written By
Posted
17745
November 05, 2007 05:33AM
Re: how to migrate oracle stored procedures to mysql
8721
December 12, 2007 11:36PM
9170
April 02, 2008 06:20PM
6419
May 20, 2008 02:47PM
6347
May 21, 2008 03:13AM
5804
May 21, 2008 07:06AM
5884
June 05, 2008 11:37PM
5059
April 13, 2009 03:00AM
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.