Re: Moving schema from DB2 to Oracle9i

From: Harry Boswell <Harry_Boswell_at_@deq.state.ms.us>
Date: Fri, 07 Jan 2005 10:26:38 -0600
Message-ID: <c0ett0h9qatr1r00el4c0vd4650cc9j1cv@4ax.com>

On Wed, 5 Jan 2005 19:59:18 +0200, "Dmitry Tolpeko" <support_at_ispirer.com> wrote:

>Hi,
>
>First try Oracle Migration Workbench, it's a free tool.
>
>Manual conversion is a complex task, since you need to convert data types,
>date/time conversion, constraints, resolve possible reserved word and
>identifier conflicts, create various control files. If you have LOBs, it
>will not be easy to create SQL Loader scripts.
>
>If OMWB has any issues, try commercial products - usually they cover more
>issues and fully automate the schema and data conversion.
>
>

That's what I'm working towards now - except that it needs the DB2 thin client to connect, and I can't seem to find the DB2 client on IBM's website.

Harry Received on Fri Jan 07 2005 - 10:26:38 CST