MySQL Workbench generate tables from EER Diagram

10.3k Views Asked by At

I am using MySQL Workbench and created an EER Diagram with several classes, columns, relationships, etc... now I have been looking and wondering if it is possible to let this application auto-generate these tables in my database? Up until now I haven't found it.

3

There are 3 best solutions below

0
Pierre On BEST ANSWER

You can try File -> Export -> Forward Engineer SQL Create Script. Here you can generate the SQL Script corresponding to your EER diagram, and execute this script in your database engine.

0
Kofi On

check out this tutorial from the MySQL website,HERE and HERE it shows how to create a connection between Workbench and the server and after that you can forward engineer any tables and such into a database. Hope it's what you're looking for.:)

1
Datawolf On

Database > Forward engineer... is a wizard who will guide you to the creation of the database you have modeled.