I have a large Postgresql 7.3 database on a Linux RHEL3 server, and I need to quickly make a very detailed ER diagram to use in a grant proposal for rewriting our (small college) system (ERW framework and PHP) into Ruby on Rails.
The developer recommended ERwin, but it is over 1,000 dollars per license, so that is out.
I tried MicroOLAP Database Designer for Postgresql, and it seems really promising. I didn't have to jump through any hoops or install anything in order to connect it to my db, and it reverse engineered the whole thing. However, when I tried to save, it crashed. I tried for four days, sending error reports to MicroOLAP, and even exchanged email with the president of the company. I would be very happy with this software, but I can't use it if I can't save the file.
I tried Toad Data Modeler, but version 3 only works for Postgresql 8.x, and I need to reverse engineer 7.3. The previous product, Case Studio 2, reportedly works with 7.3, but even though I was able to download it, there is no trial key, so I can't test it out.
I tried ConceptDraw, also. It supposedly can reverse engineer databases through ODBC, and I went through the trouble of setting up ODBC in order to test it. However, I can't find the reverse engineer command or menu or dialog. There was a community forum on the company's website, where the company moderator gave a short howto on reverse engineering, but the template she refers to is not in software. I replied to her, and so did another user, and she never got back to us. The other user's reply was sent over a year ago, so I don't think ConceptDraw is going to work.
I am under a tight deadline for getting this estimate, and I need this ER diagram to do so, so I would really appreciate any advice any of you have.