Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Tool for convert SQL code to diagram

can any one say some way to convert SQL code to data diagram like ERD ? for som DBMS like MySQL or general SQL

like image 671
Sajad Bahmani Avatar asked May 14 '10 19:05

Sajad Bahmani


3 Answers

using mysql Workbench do the following:

1- file -> new model

2- file -> import -> reverse engineer mysql create script

select ur mysql file script

and tick on place imported objects on a diagram

and press next and finish

like image 51
Ahmed M. Matar Avatar answered Sep 18 '22 13:09

Ahmed M. Matar


Use MySQL WorkBench. It's perfect and absolutely compatible with MySQL, Oracle powered!

Check it out here: MySQL Workbench

like image 45
sstauross Avatar answered Sep 20 '22 13:09

sstauross


ModelRight, http://www.modelright.com/ , is a good ERD application and is free for MySQL and ODBC connected databases. It reverse engineers from a DB, if you want to reverse engineer from SQL Script, you should check out Dezign for Databases, http://www.datanamic.com/

like image 32
Dwight T Avatar answered Sep 19 '22 13:09

Dwight T