sounds like I reinvented the wheel but here's how I did it:
1. reverse engineer Oracle database with ERWin
2. write a little perl program to map/convert column types and convert syntax
for alter table clauses
3. write a sqlplus script which dynamically creates a select/spool for a given
table from dba_tab_columns
4. use load data to suck in flat files from step 3
there were some things I had to do manually/one-off but that was surprisingly
reliable for most of the migration.
Sid Lane
DBA - Site Operations
TWCi
|---------+---------------------------->
| | Arunachalam |
| | <[EMAIL PROTECTED]|
| | .uk> |
| | |
| | 01/28/2004 02:46 |
| | AM |
| | |
|---------+---------------------------->
>------------------------------------------------------------------------------------------------------------------------------|
|
|
| To: Claire Lee <[EMAIL PROTECTED]>
|
| cc: [EMAIL PROTECTED]
|
| 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]
