Menu
i want tool for to generate DB diagram below, i need to generate particular db tables structure like below,
how can i do that?...is there any free tool or application is available for that. i already tried navicat8lite_ora_en and HeidiSQL. but i can't make it work.
951
cPanel VPS and dedicated server administrators can access phpMyAdmin from WebHost Manager (WHM). Select the appropriate database name from the left of phpMyAdmin. In the upper-right corner select the “Designer” tab to create a database ER diagram (ERD).
Open MySQL Workbench. Select File and New Model from the top menu. Select File, hover over Import, and press Reverse Engineer MySQL Create Script…. Specify the SQL file needing a diagram. Press Execute, Next, and then Finish.
Yes! You can export your ERD back into your MySQL, PostgreSQL, SQL Server, or Oracle database. Select the export feature within the entity relationship shape library, choose your DBMS, and Lucidchart will change the syntax of our SQL commands to automatically generate commands you can apply to your matching database.
Yes you can generate ERD with PHPMyAdmin. PHPMyadmin added this functionality from version 3.4
detail step to generate ERD: http://sforsuresh.in/generating-erd-using-phpmyadmin/
You can refer to PHPMyAdmin documentation for more info: http://www.phpmyadmin.net/documentation/#pmadb
170
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
