migration toolkit (from oracle 9.x to udb 8.2.2)

[_link98]

Does IBM publish a complete list of features
(of Oracle) which the IBM migration toolkit
does *not* convert? The docs seem rather vague.

For example:
1. What support for the oracle object-relational features
(objects and member procedures etc).

2. any support for removing substitutable parameters
in DDL (in sqlplus scripts) like "&&1". or &&1.. etc.
In the simplest case, removing these from DDL where
they are used as qualifiers on tables/views/etc.

3. support for converting the style "VARCHAR2(8 BYTE)"
(presumably converting to VARCHAR(8)).

4. support for structured types in table columns.

5. which features of Oracle PL/SQL are not supported.

[Serge Rielau]

_l*****@yahoo.com wrote:

Does IBM publish a complete list of features
(of Oracle) which the IBM migration toolkit
does *not* convert? The docs seem rather vague. Ever seen a product that provides you with a negative list?
Let me know I want to sell my shares.
For example:
1. What support for the oracle object-relational features
(objects and member procedures etc). The migration toolkit concentrates on common Oracle features.
OR features are not common.
DB2 does support typed tables, typed views, methods, ref-types and
structured datatypes as defined in the SQL 99 standard.
2. any support for removing substitutable parameters
in DDL (in sqlplus scripts) like "&&1". or &&1.. etc.
In the simplest case, removing these from DDL where
they are used as qualifiers on tables/views/etc. I would use a pre-compiler for those. Many C compilers allow you to call
the pre-compiler separately.
3. support for converting the style "VARCHAR2(8 BYTE)"
(presumably converting to VARCHAR(8)). VARCHAR2 being a common Oracle type is supported by MTK.
4. support for structured types in table columns. See OR features. Not common. No support.
Should be easy to migrate though. My concern is around LOADing into such
tables though. Since structured types are not supported by LOAD.
5. which features of Oracle PL/SQL are not supported.

There is no such list.
MTK supports the vast majority of PL/SQL features. Including %ROWTYPE
and %TYPE. I think it migrates handlers as well.

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab

[Will Honea]

On Tue, 9 Aug 2005 17:24:22 UTC _l*****@yahoo.com wrote:

Does IBM publish a complete list of features
(of Oracle) which the IBM migration toolkit
does *not* convert? The docs seem rather vague.

For example:
1. What support for the oracle object-relational features
(objects and member procedures etc).

2. any support for removing substitutable parameters
in DDL (in sqlplus scripts) like "&&1". or &&1.. etc.
In the simplest case, removing these from DDL where
they are used as qualifiers on tables/views/etc.

3. support for converting the style "VARCHAR2(8 BYTE)"
(presumably converting to VARCHAR(8)).

4. support for structured types in table columns.

5. which features of Oracle PL/SQL are not supported.

The O'Reilly book "SQL ina A Nutshell" has a fairly decent comparison
but it's organized more on a feature-by- feature basis than as a table
and also includes Postres and SQ server info so it would take some
digging on individual features.

--
Will Honea