Tool for documenting an existing informix DB
Someone asked for a tool to reverse-engineer and document an existing IDS 7.3 database as an ER diagram, having found Visible Analyst poor with Informix. No single answer, but several recommendations: ERwin (good but pricey), Sybase/PowerDesigner and System Architect (Platinum/CA), Embarcadero ER/Studio (eval available), and InfoModeler (simpler, cheaper, then recently acquired by Visio) for basic table/PK/FK graphics. Posters noted ERwin and ER/Studio give best results only if referential integrity is properly defined. The original poster never reported which he chose.
Auto-generated by DrWatson from the posts below — may be imperfect; read the full thread.
Hi, does anybody know about a good tool for documenting an existing database running on IDS 7.3 ? It should be able to analyze the database and output an ERD Diagramm. I have checked out Visible Analyst, but it does not work very well with informix. Uli -- Ulrich Eckhardt Tr@nscom http://www.uli-eckhardt.de http://www.transcom.de Lagerstraße 11-15 A8 64807 Dieburg Germany
Ulrich Eckhardt <Ulrich.Eckhardt@transcom.de> writes: > Hi, > > does anybody know about a good tool for documenting > an existing database running on IDS 7.3 ? It should > be able to analyze the database and output an ERD > Diagramm. > > I have checked out Visible Analyst, but it does not > work very well with informix. ErWin and Sybase Designer are pretty good. Thomas
I've used ErWin, and it works pretty well as long as your RI is set up well. In article <392CF82C.F37ACD6E@transcom.de>, Ulrich Eckhardt <Ulrich.Eckhardt@transcom.de> wrote: > Hi, > > does anybody know about a good tool for documenting > an existing database running on IDS 7.3 ? It should > be able to analyze the database and output an ERD > Diagramm. > > I have checked out Visible Analyst, but it does not > work very well with informix. > > Uli > -- > Ulrich Eckhardt Tr@nscom > http://www.uli-eckhardt.de http://www.transcom.de > Lagerstra'e 11-15 A8 > 64807 Dieburg Germany > -- # unrm / ksh: unrm: not found # man cpio Sent via Deja.com http://www.deja.com/ Before you buy.
In article <392CF82C.F37ACD6E@transcom.de>, Ulrich Eckhardt <Ulrich.Eckhardt@transcom.de> wrote: > Hi, > > does anybody know about a good tool for documenting > an existing database running on IDS 7.3 ? It should > be able to analyze the database and output an ERD > Diagramm. > > I have checked out Visible Analyst, but it does not > work very well with informix. > > Uli > -- > Ulrich Eckhardt Tr@nscom > http://www.uli-eckhardt.de http://www.transcom.de > Lagerstra'e 11-15 A8 > 64807 Dieburg Germany > Try www.embarcadero.co.uk for their ER/Studio product. There is an eval available there too. As others have stated, ERWin is also an excellent product (although pricey) - I'm not sure who markets ERWin these days. Both these products expect Referential Integrity for best results. Regards Mr Creosote -- "Just a waffer thin mint?" Sent via Deja.com http://www.deja.com/ Before you buy.
i like the simplicity of infomodeler, at least for producing a graphic of the tables, with fk and pk etc. it is not as complete as ERwin, but not as cumbersome either. Ulrich Eckhardt wrote: > Hi, > > does anybody know about a good tool for documenting > an existing database running on IDS 7.3 ? It should > be able to analyze the database and output an ERD > Diagramm. > > I have checked out Visible Analyst, but it does not > work very well with informix. > > Uli > -- > Ulrich Eckhardt Tr@nscom > http://www.uli-eckhardt.de http://www.transcom.de > Lagerstraße 11-15 A8 > 64807 Dieburg Germany
Is infomodeler a high-end and, therefore, expensive tool? We are looking for a simple tool that can used to graphically represent our database. We don't need all the design power that tools such as ERwin provide but would like to hae access to the documentation components. Where does one find infomodeler? Thanks! ...Jake >>>>> "ER" == Edward Rosenthal <edrosenthal@home.com> writes: ER> i like the simplicity of infomodeler, at least for producing a ER> graphic of the tables, with fk and pk etc. it is not as complete as ER> ERwin, but not as cumbersome either. -- Jake Colman Principia Partners LLC Phone: (201) 946-0300 Harborside Financial Center Fax: (201) 946-0320 902 Plaza II Beeper: (800) 928-4640 Jersey City, NJ 07311 E-mail: colman@ppllc.com E-mail: jcolman@jnc.com web: http://www.ppllc.com microsoft: "where do you want to go today?" linux: "where do you want to go tomorrow?" BSD: "are you guys coming, or what?"
it was recently acquired by Visio. check the website for visio and call 'em. Jake Colman wrote: > Is infomodeler a high-end and, therefore, expensive tool? We are looking for > a simple tool that can used to graphically represent our database. We don't > need all the design power that tools such as ERwin provide but would like to > hae access to the documentation components. > > Where does one find infomodeler? > > Thanks! > > ...Jake > > >>>>> "ER" == Edward Rosenthal <edrosenthal@home.com> writes: > > ER> i like the simplicity of infomodeler, at least for producing a > ER> graphic of the tables, with fk and pk etc. it is not as complete as > ER> ERwin, but not as cumbersome either. > > -- > Jake Colman > > Principia Partners LLC Phone: (201) 946-0300 > Harborside Financial Center Fax: (201) 946-0320 > 902 Plaza II Beeper: (800) 928-4640 > Jersey City, NJ 07311 E-mail: colman@ppllc.com > E-mail: jcolman@jnc.com > web: http://www.ppllc.com > > microsoft: "where do you want to go today?" > linux: "where do you want to go tomorrow?" > BSD: "are you guys coming, or what?"
I have been successful at reverse engineering Informix databases using Power Designer - System Architect from Platinum, now owned by CA. S. Athey Edward Rosenthal wrote in message <392E8305.85C54F04@home.com>... >i like the simplicity of infomodeler, at least for producing a graphic >of the tables, with fk and pk etc. >it is not as complete as ERwin, but not as cumbersome either. > >Ulrich Eckhardt wrote: > >> Hi, >> >> does anybody know about a good tool for documenting >> an existing database running on IDS 7.3 ? It should >> be able to analyze the database and output an ERD >> Diagramm. >> >> I have checked out Visible Analyst, but it does not >> work very well with informix. >> >> Uli >> -- >> Ulrich Eckhardt Tr@nscom >> http://www.uli-eckhardt.de http://www.transcom.de >> Lagerstra'e 11-15 A8 >> 64807 Dieburg Germany >