Groups > Databases > MySQL for ASP.NET > Re: Migration from MySql 5.0 to oracle 9i




Migration from MySql 5.0 to oracle 9i

Migration from MySql 5.0 to oracle 9i
Wed, 2 Apr 2008 15:13:32 +0000
Hi,
Can anyone tel me how to migrate MySql 5.0 database to oracle 9i..
Do there comes any datatype conflict?  If so tell me in detail.
Or just give me any URL to look into this concept.

Migration from MySql 5.0 to oracle 9i

Regards,
Tamizhselvi
Post Reply
Re: Migration from MySql 5.0 to oracle 9i
Wed, 2 Apr 2008 17:13:12 +0000
Hi there,

You can use some  utilities to convert your database from MySQL to Oracle check
out this, but you will need to fix some minor things by youself:

http://www.convert-in.com/sql2ora.htm 

http://www.oracle.com/technology/tech/migration/workbench/index.html 

if you are using ASP.NEt in front end with ODBC connection then there is no
problem, but if you are using .NEt Connector for MySQL then you will need to
change Data Access code to your Oracle format.

thanks
Post Reply
about | contact