Re: Migrating to Oracle on Windows

On May 20, 1:18 am, DA Morgan <damor..._at_psoug.org> wrote:
> goooooglegro..._at_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
>
> If your organization has enough money to have DB2 on z/OS there is
> essentially no excuse for moving to Windows, definitely no excuse
> for looking for free software, and absolutely no excuse for passing
> this to someone with zero training.
>
> More information and version numbers required. Before I would offer
> help some assurances that this isn't just a troll. Because what you
> wrote above is outrageous and an absolute guarantee of failure.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org

Hi,

The example I gave of migrating from DB2 on z/OS to Oracle on Windows is just one example - in general I want to be able to move a database from Oracle to DB2, and vica-versa, on both Windows and z/OS.

Even a process to move the data from DB2 on z/OS to Oracle on Windows would be a good start as I already have the database structure setup on both, but ideally I would like to take a database on DB2 (z/OS) and create a similiar one on Oracle and then copy across all the data.

I see Oracle have a tool

   http://www.oracle.com/technology/tech/migration/workbench/index.html

which handles most of this, however it does not handle migrating from DB2 on z/OS to Oracle on Windows, hence why I am tackling this particular setup.

The version of Oracle I am using is 10.2.0 the version of DB2 I am using is 9.

I would have thought that this would be a common thing to do and thus would have a solution that was well known among the database community - so I am just looking for some help\guidance.

Thanks,

Noel Received on Sun May 20 2007 - 10:16:44 CDT