MySQL Bugs: #70968: Generate CREATE SQL on an EER diagram basis

Bug #70968	Generate CREATE SQL on an EER diagram basis
Submitted:	21 Nov 2013 10:02	Modified:	31 Jan 2018 16:05
Reporter:	Francis Chuang	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Workbench: Modeling	Severity:	S4 (Feature request)
Version:	6.3.10	OS:	Any
Assigned to:		CPU Architecture:	Any
Tags:	EER Diagram, SQL

Description:
I would love to be able to generate CREATE SQL statements and files on an EER diagram basis.

For example, in my model, I have 2 EER diagrams:
In diagram 1, I have table1 and table2. In diagram 2, I have table3.

I would love to be able to generate a CREATE SQL file for diagram 1 that contains definitions for table 1 and 2. Then, generate another CREATE SQL file for diagram 2 that contains definitions for table3.

How to repeat:
This feature is currently unavailable.

You should be able to use filtering to pick what tables to include in your CREATE script.

Yes, that's what I am doing at the moment.

Unfortunately, it's quite tedious and error-prone, especially if you have got a lot of tables and multiple EER diagrams.

I believe this is a good suggestion.

Intuitively, when I am working on a diagram I will want to export the table definitions to a SQL script, but only for that diagram.

Manually filtering the required tables is indeed tedious and time consuming and prone to error.

Suggestion
=======
Add a diagram selection filter to the Forward Engineering and Synchronize model wizards.

The filter will then preselect all tables in the selected diagram.

Thank you for the feature request.