Re: Migration from MySQL

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Fri, 16 Mar 2007 22:38:44 +0100
Message-ID: <560h35F26hvslU2@mid.individual.net>

On 16.03.2007 22:13, DA Morgan wrote:
> nendee wrote:

>> We've been trying to convert a MySQL database to Oracle.  As it
>> stands, the Oracle Migration Workbench is a complete no starter - some
>> of the data columns aren't converted correctly, etc.
>>
>> So, we created a "safe" version of the DDL and would like to create
>> control files directly from this DDL.  Does anyone know if this is
>> possible?

>
> There is no way to use SQL*Loader to do what you are trying to do.
> Also, it would be best practice to not build generic tables in
> Oracle that are identical with those you had in MySQL without first
> determining whether they are the best solution for what you are
> doing.
>
> My recommendation would be to hand-write, yes I know it is a pain,
> your DDL and execute it as a script that also builds constraints
> and indexes. Then create a control file, and yes again by hand as
> I know of no tool that will do it for you, and run SQL*Loader from
> the command line.

Just to throw in my 2 cents: SQL Server's DTS is pretty nifty - I know it can transfer a lot of the original structure but I am not sure how good it would work in this particular case (MySQL -> Oracle).

Kind regards

        robert Received on Fri Mar 16 2007 - 16:38:44 CDT