How to get ER model of database from server with W

2019-01-29 21:10发布

问题:

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

回答1:

  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.


回答2:

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.

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

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

Enjoy :)



回答3:

  1. Migrate your DB "simply make sure the tables and columns exist".
  2. Recommended to delete all your data (this freezes MySQL Workbench on my MAC everytime due to "software out of memory..")

  1. Open MySQL Workbench
  2. click + to make MySQL connection
  3. enter credentials and connect
  4. go to database tab
  5. click reverse engineer
  6. follow the wizard Next > Next ….
  7. DONE :)
  8. now you can click the arrange tab then choose auto-layout (keep clicking it until you are satisfied with the result)


回答4:

On mac, press Command + R or got to Database -> Reverse Engineer and keep selecting your requirements and continue