xtanto_at_hotmail.com wrote:
> Hi Frank,
>
>
>>OMWB will *not* migrate data
>
> It will, I have done that, a database in Sql Server became a schema in
> Oracle.
> But the problem is :
> (1) (2) (3)
> SqlServer -> Oracle (old structure )-> Oracle New Structure
>>From (2) to (3) I have to do :
> INSERT INTO [New Structure] SELECT * FROM [Old Structure]
> Do you mean I have to EXPORT the [old structure] into TEXT and RUN
> SqlLoader ?
> Is this the best method ?
>
>
>>You only have one option: SQL*Loader.
>
> Could you pls explain why ?
>
> Thank you,
> Krist
>
Why would I? You seem to know you can with OMWB; be my guest
--
Regards,
Frank van Bortel
Received on Thu Mar 24 2005 - 07:04:57 CST
