Johan,
I'm working on something similar at the moment.
Attached at two files I downloaded from somewhere. If you import/attach
the
Oracle tables to an access database you could give them a try - I haven't
used them.
If you want a more complete solution, the Oracle views: USER_TABLES,
USER_TAB_COLUMNS,
USER_INDEXES, USER_CONSTRAINTS, USER_CONS_COLUMNS will give you the complete
structure
of the Oracle DB. (Also ALL_TABLES, ALL_TAB_COLUMNS, ALL_INDEXES,
ALL_CONSTRAINTS,
ALL_CONS_COLUMNS). You'd need to write some sort of program to make use of
these
though.
Cheers,
Bruce
PS: I'm very new to MySQL
-----Original Message-----
From: Johan Andersson [mailto:[EMAIL PROTECTED]]
Sent: Thu, 26 April 2001 11:26
To: '[EMAIL PROTECTED]'
Subject: Migration Oracle => MySQL
Anybody tried this? and hopefully got some good ideas of how to do it
properly?
I'm trying to create a perl script that just produces a MySQL compliant
SQL file based on the tables from Oracle, but I can't get everything work,
like indexes etc..
Someone?
// Johan Andersson
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
