Re: Migration Workbench (OMWB) vs SQL Loader

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Wed, 23 Mar 2005 18:13:15 +0100
Message-ID: <d1s7tq$ait$1@news6.zwoll1.ov.home.nl>

krislioe_at_gmail.com wrote:
> Hi All,
>
> I am migrating SQL Server 2000 (Windows 2000) data into Oracle 9i on
> AIX. The table structure is changed in Oracle, but not very
> significantly.
>
> The options are using Migration Workbench (OMWB) or SQL Loader.
>
> Could anybody please tell me, what are the cases / reason to decide
> whether to use OMWB or SQL Loader ??
>

Two completely different products, targeted at completely different things.
OMWB will *not* migrate data - it can generate batches to load data, using SQL*Loader; it will even extract the data from SQL Server.

You only have one option: SQL*Loader.

-- 
Regards,
Frank van Bortel

Received on Wed Mar 23 2005 - 11:13:15 CST