Hi!

Is there a utility to migrate mysql databases (windows) to oracle 9i
(linux)?

Timo

You could try using DTS (Data Transformation Services) which is part of
Microsoft SQL Server :-)

"Timo Nentwig" <tcn (AT) spamgourmet (DOT) com> wrote

Fari paladon wrote:

# ./exp --help
LRM-00116: syntax error at '-' following '-'

EXP-00019: failed to process parameters, type 'EXP HELP=Y' for help
EXP-00000: Export terminated unsuccessfully

# ./imp --help
LRM-00116: syntax error at '-' following '-'

IMP-00022: failed to process parameters, type 'IMP HELP=Y' for help
IMP-00000: Import terminated unsuccessfully

;-)

Well, as I understand the commands they log on to a db and query it via SQL,
don't they? What I need is a direct native file import of the MySQL db
storage files... :-\

Thanks
Timo

On Sat, 19 Jul 2003 17:57:29 +0200, Timo Nentwig <tcn (AT) spamgourmet (DOT) com>
wrote:

Not likely.
I can see two alternatives: You could get MS Access to the job
provided you have an ODBC driver for MySQL and ditto for Oracle. The
latter is included with the Oracle client for Winblows

The second method will work, but is also more cumbersome:
export the tables as comma-separated CSV files, one table per file,
and use the sqlloader product to load the files. And, sorry, I'm not
going to abstract the sqlloader manual here. It is in the Oracle
Server Utilities Manual


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address