Menu
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
472
If your script creates a database, MySQL Workbench creates a new Physical Schemas area within the open MySQL Model tab. Click Execute to reverse-engineer the SQL script, verify its results, and optionally place the objects in a new EER diagram. The next figure shows an example of the finished operation.
To reverse engineer database go to menu Database and choose Reverse Engineer... option. Provide connection details to your database and click Next. Wait for the connection and click Next again.
9.4.1 Forward Engineering 9.4.2 Reverse Engineering. MySQL Workbench provides capabilities to forward engineering physical database designs. A visual data model can be transformed into a physical database on a target MySQL Server by executing the forward engineering wizard.
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).
92
I recommend DBeaver: multi-platform, free, open source, connects to most popular DB engines and supports reverse engineering.
I have tried reverse engineering both a MySQL DB and a PostgreSQL DB and it worked like a charm :)
40
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
