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. David ----- Original Message ----- From: "Arunachalam" <[EMAIL PROTECTED]> To: "Claire Lee" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> 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. > > greets, > > Arun. > > --- Claire Lee <[EMAIL PROTECTED]> 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: http://lists.mysql.com/[EMAIL PROTECTED] > > > > ________________________________________________________________________ > 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/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
