Re: Migration from MySQL

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Sun, 18 Mar 2007 18:58:03 -0500
Message-ID: <45fdc593$0$16272$88260bb3@free.teranews.com>

Robert Klemme wrote:

> 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

DTS works really well from MySQL to Oracle. I've used that in the past. Many times that I've used DTS, I've never even involved SQL Server. This is the one product I wish Oracle had a companion for in its toolset.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

-- 
Posted via a free Usenet account from http://www.teranews.com

Received on Sun Mar 18 2007 - 18:58:03 CDT