|
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. >
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.