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
If we're going to go that route then ERwin ... which would do it
nicely. But that wasn't on the OP's list either. <g>
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Fri Mar 16 2007 - 20:22:12 CDT
