And if you have lots of $$$ to spend, Embarcadero (www.embarcadero.com) has
a tool called ERStudio, that can generate the Data Definition Language (DDL)
for MySQL from Oracle. Costs are pretty excessive.
We've purchased a SQLWays licence, and I've used it a fair bit - it's a
decent tool for data, but I've never used it for tables/indexes/foreign
keys. Quite a bit cheaper than ERStudio.
----- Original Message -----
From: "Arunachalam" <arunchp@stripped>
To: "Claire Lee" <jingli71@stripped>
Sent: Tuesday, January 27, 2004 11:46 PM
Subject: Re: porting Oracle schema to MySQL
> look at http://www.ispirer.com
> it provides a tool SQLWays, which is a migrating tool
> to migrate any DataBase to MySQL with Data.
> --- Claire Lee <jingli71@stripped> wrote: > Hi,
> > I'm a newbie working on a big project. The idea is to
> > transport an existing Oracle database at
> > http://www.ebi.ac.uk/arrayexpress/ to a local MySQL
> > server. The Schema, scripts and loader for Oracle can
> > be found in the website. But how to create an exactly
> > same database with mySQL? I have no clue. Really need
> > help. Thanks in advance.
> > Claire
> > __________________________________
> > Do you Yahoo!?
> > Yahoo! SiteBuilder - Free web site building tool. Try it!
> > http://webhosting.yahoo.com/ps/sb/
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> Yahoo! India Mobile: Download the latest polyphonic ringtones.
> Go to http://in.mobile.yahoo.com
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1