Migrating from DB2 on z/OS

[gooooog...@yahoo.com]

Hi,

I am looking into migrating a database from DB2 on z/OS to Oracle on
Windows.

I am quite new to databases and would appeciate any information on
free programs that do this or a good process for carrying this out.

Thanks,

Noel

[swami]

Hi,

This seems to be a long process.
1) Generate DDL from DB2
2) Convert the DDL to Oracle DDL's ( manual change is required )
3) Create the Database Structure in Oracle
4) Migrate the DATA.

All the Best.
Please let me know if you find any other way.
Swami

---------------------------------------------------------------------------------------------------------------------

[Serge Rielau]

swami wrote:
> Hi,
>
> This seems to be a long process.
> 1) Generate DDL from DB2
> 2) Convert the DDL to Oracle DDL's ( manual change is required )
> 3) Create the Database Structure in Oracle
> 4) Migrate the DATA.

.. That would be commonly known as the tip of the ice berg.
then comes the app, stored procedures, functions, triggers...details,
details

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[gooooog...@yahoo.com]

Thanks for the replies.

At a minimum I want to be able to just take data from tables from DB2

on z/OS to Oracle on Windows.

Ideally I would like to take the table structure from DB2 on z/OS and
recreate the table in Oracle on Windows. Then copy all the data from
the tables in DB2 to the new tables in Oracle.

So, I don't want to recreate everything - just the tables and the
contents of the tables.