Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to get ER model of database from server with Workbench

Tags:

mysql

mysql-workbench

entity-relationship

Is there any way to get an ER model of a database from the server that is connected to my MySQL Workbench?

like image 673
zdarsky.peter Avatar asked Sep 29 '22 04:09

zdarsky.peter

People also ask

How do I export an ER diagram in MySQL Workbench?

Open your ERD and then go to File -> Export and you'll find there that you can export the whole model to PNG or SVG which you can convert later to JPEG if you want to.

How do I get ERD from SQL Server?

Create ER diagram in SSMSOpen SQL Server Management Studio (SSMS). In the Object Explorer on the left, expand your database. Right-click on Database Diagrams, and then select New Database Diagram.

2 Answers

  1. Go to "Database" Menu option
  2. Select the "Reverse Engineer" option.
  3. A wizard will be open and it will generate the ER Diagram for you.
like image 412
Kamran Ali Avatar answered Oct 08 '22 22:10

Kamran Ali

I want to enhance Mr. Kamran Ali's answer with pictorial view.

Pictorial View is given step by step:

  1. Go to "Database" Menu option
  2. Select the "Reverse Engineer" option.

enter image description here

  1. A wizard will come. Select from "Stored Connection" and press "Next" button.

enter image description here

  1. Then "Next"..to.."Finish"

Enjoy :)

like image 61
SkyWalker Avatar answered Oct 08 '22 23:10

SkyWalker
Sign in to Comment

Related questions

Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
Delimiters in MySQL
How to add not null constraint to existing column in MySQL
ERROR 1044 (42000): Access denied for user ''@'localhost' to database 'db'
Is there a way to only install the mysql client (Linux)? [closed]
Which is fastest? SELECT SQL_CALC_FOUND_ROWS FROM `table`, or SELECT COUNT(*)
Doctrine - How to print out the real sql, not just the prepared statement?
Mysql command not found in OS X 10.7
How do I turn off the mysql password validation?
MySQL user DB does not have password columns - Installing MySQL on OSX
Delete sql rows where IDs do not have a match from another table
If table exists drop table then create it, if it does not exist just create it
MySQL stored procedure vs function, which would I use when?
Is there a naming convention for MySQL?
How to recover MySQL database from .myd, .myi, .frm files
Select records from NOW() -1 Day
Throw an error preventing a table update in a MySQL trigger
On duplicate key ignore? [duplicate]
How to create a database from shell command?
MySQL - UPDATE multiple rows with different values in one query

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!