REPOST: Re: mysql to oracle migration

Hi,

Unlike MySQL you can have one database per Oracle server (instance). Probably you have to move MySQL databases into one Oracle database. For each MySQL database you can create a schema in the Oracle database.

Consider rewriting application (web site) logic using stored procedures. Also Oracle SQL is much better than MySQL SQL.

There are some migration tool that can help you to migrate MySQL databases into Oracle, for example Oracle Migration Workbench (http://technet.oracle.com), Chyfo (www.ispirer.com/products)

 Best regards, Dmitry

"philip johnson" <philip.johnson_at_wanadoo.fr> wrote in message news:a2q9rq$86n$1_at_wanadoo.fr...
> What you should know is that we have Oracle Application.
> We have many databases from intranet, and some other little applications.
>
> What could justify, expect the fact we need to pay, a migration from
mysql
> to oracle ?
>
>

• WAS CANCELLED BY =======: From: "Dmitry" <support_at_ispirer.com> Control: cancel <a2rpml$13e2dh$1_at_ID-75577.news.dfncis.de> Subject: cmsg cancel <a2rpml$13e2dh$1_at_ID-75577.news.dfncis.de> Date: Mon, 28 Jan 2002 01:04:25 GMT Message-ID: <cancel.a2rpml$13e2dh$1_at_ID-75577.news.dfncis.de> X-No-Archive: yes Newsgroups: microsoft.test,alt.flame.niggers,comp.databases.oracle.server NNTP-Posting-Host: w088.z064003087.lax-ca.dsl.cnc.net 64.3.87.88 Lines: 1 Path: news.uni-stuttgart.de!dns.phoenix-ag.de!newsfeed01.sul.t-online.de!t-online.de!fr.clara.net!heighliner.fr.clara.net!diablo.netcom.net.uk!netcom.net.uk!newsfeed.icl.net!newsfeed.esat.net!nntp.cifnet.net!out.nntp.be!propagator-SanJose!in.nntp.be!news-in-sanjose!sjc-feed.news.verio.net!sea-feed.news.verio.net!news.verio.net!msrnewsc1!cppssbbsa01.microsoft.com!tkmsftngp01!tkmsftngp04!u&n&a&c&anceller Xref: news.uni-stuttgart.de control:40723500

This message was cancelled from within The Unacanceller's glorious new software, Lotus 1-2-3 For Rogue Cancellers. Received on Fri Jan 25 2002 - 08:21:24 CST