MySQL Forums
Forum List  »  Oracle

Re: HOW TO CONVERT ORACLE DB APP TO MYSQL
Posted by: Roland Bouman
Date: February 06, 2007 06:18AM

ipbasu,

regardless of available tools, there are a few things that won't readily migrate from Oracle to MySQL:

-code: all triggers, functions, stored procedures and views must be manually coded anew in MySQL.
-check constraints: mysql does not have check constraints, so you are going to have to take care of those in another way (you can sometimes use MySQL triggers to do that)

For data and table structure migration take a look at the migration toolkit (download it from the mysql website). It is bundled with the MySQL GUI tools. Alas, the Migration Toolkit is available only in the windows distribution.

Options: ReplyQuote


Subject
Views
Written By
Posted
43763
January 03, 2005 10:56PM
25606
February 10, 2005 05:20PM
12601
August 26, 2005 03:28AM
11250
March 09, 2006 06:57AM
10559
March 09, 2006 02:09PM
7815
June 20, 2006 06:42PM
6261
January 23, 2006 10:37AM
5169
January 23, 2006 02:26PM
4641
September 30, 2006 01:18AM
5115
February 06, 2007 12:17AM
Re: HOW TO CONVERT ORACLE DB APP TO MYSQL
6990
February 06, 2007 06:18AM


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.