Is there an application to reverse engineer an existing database in mysql and/or postgre?
I'm interested in obtaining the DB diagram from an existing one, similar as it can be done in MSSQL Server
+1
A:
Reverse engineer from many popular DBMS systems, including Oracle 9i and 10g, SQL Server, My SQL, Access, PostgreSQL and others
Mitch Wheat
2009-03-22 02:41:32
+5
A:
For MySQL, try MySQL Workbench.
For both MySQL and PostgreSQL, try TOAD Data Modeler.
If you use the open-source diagram app Dia, there are several tools to generate Dia diagrams from SQL databases including MySQL and PostgreSQL.
update: MySQL Workbench 5.2 supports reverse-engineering diagrams from a live database in addition to an SQL script. MySQL Workbench 5.2 just announced their Release Candidate 1 (as of 5/12/2010).
Bill Karwin
2009-03-22 02:52:48
Do you need a plugin to get MySQL Workbench reverse engineer working? Where can I get it?
Raúl Roa
2009-03-22 03:39:18
MySQL Workbench 5.1 is in beta now and it seems reverse engineering works only on a SQL script in the current version. I don't know if or when a plugin will be available.
Bill Karwin
2009-03-22 03:52:22
Thanks, I had MySQL Workbench already but the reverse engineering works as you say from a CREATE DATABASE SQL script. You should check out DBVisualizer.
Raúl Roa
2009-03-22 19:25:55