Re: Copy Oracle database to DB2/400

I feel I must respond to this...

Expensive? Considering what the tools can do.... I must strongly disagree.

If you want to draw pretty pictures, then yes, it's too expensive.
If you want to reverse engineer the database, then probably not.

If you want to reverse engineer a database, document it, publish it to the
web, make design changes and enforce referential integrity, assign triggers,
publish the changes to the web and create a non-trivial ALTER script that
can then be run and in minutes (not days) make the changes, then the tool is
CHEAP!

ERStudio from Embarcadero is about the same price as ERWin.

Other tools that are "free" or less than a few hundred dollars are (IMHO)
toys and can not compete and will waste my time and my client's dollars. If
I wanted to waste time, I would have become an Oracle DBA where I can while
away my hours deciding how to partition the hard drives and then somehow
move my data without having to resort to a full restore.... i digess....

If you are serious about database, these tools will serve you well into the
future. If you only want to do this thing one time and never work with SQL
for database definition, maintenance, documentation and design ever again,
then don't buy the tool.

===========================================================
R. Bruce Hoffman, Jr.
 -- IBM Certified Specialist - AS/400 Administrator
 -- IBM Certified Specialist - RPG IV Developer

"America is the land that fought for freedom and then
  began passing laws to get rid of it."

     - Alfred E. Neuman

-----Original Message-----
From: Phil <sublime78ska@yahoo.com>
To: midrange-l@midrange.com <midrange-l@midrange.com>
Date: Monday, October 29, 2001 12:21 PM
Subject: RE: Copy Oracle database to DB2/400


>Anyone know of any ERD tools besides ERWin?
>
>ERWin is very expensive.
>
>Phil
>
>> -----Original Message-----
>> From: midrange-l-admin@midrange.com
>> [mailto:midrange-l-admin@midrange.com]On Behalf Of David.X.Kahn@gsk.com
>> Sent: Monday, October 29, 2001 3:57 AM
>> To: midrange-l@midrange.com
>> Subject: Re: Copy Oracle database to DB2/400
>>
>>
>> > Reverse engineer the database schemas into ERWin.
>>
>> Thanks, Bruce. Definitely worth investigating. Next meeting with
>> the Oracle
>> group is planned for tomorrow.
>>
>> Dave...
>>
>> "Achilles only had an Achilles' heel; I have a whole Achilles' body." -
>> Woody Allen
>>
>> =======================================================
>> The opinions expressed in this communication are my own and do not
>> necessarily reflect those of my employer.
>>
>> _______________________________________________
>> This is the Midrange Systems Technical Discussion (MIDRANGE-L)
>> mailing list
>> To post a message email: MIDRANGE-L@midrange.com
>> To subscribe, unsubscribe, or change list options,
>> visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>> or email: MIDRANGE-L-request@midrange.com
>> Before posting, please take a moment to review the archives
>> at http://archive.midrange.com/midrange-l.
>>
>
>_________________________________________________________
>Do You Yahoo!?
>Get your free @yahoo.com address at http://mail.yahoo.com
>
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.
>