By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,454 Members | 1,804 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,454 IT Pros & Developers. It's quick & easy.

Migrating from DB2 on z/OS

P: n/a
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

May 19 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
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

---------------------------------------------------------------------------------------------------------------------
go*************@yahoo.com wrote:
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
May 21 '07 #2

P: n/a
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
May 22 '07 #3

P: n/a
On May 22, 1:43 am, Serge Rielau <srie...@ca.ibm.comwrote:
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

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.

May 22 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.