Bug #39351 Need option to forward engineer SQL without database name
Submitted: 9 Sep 2008 21:49 Modified: 8 Feb 2010 11:48
Reporter: Dyami Caliri Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench Severity:S4 (Feature request)
Version:5.1 OS:Windows (XP)
Assigned to: Alexander Musienko CPU Architecture:Any
Tags: Database name, forward engineer

[9 Sep 2008 21:49] Dyami Caliri
Description:
It would be very helpful to create a schema that wasn't tied to a specific database name. We typically load the same schema into a normal development database and also a test database.

The current SQL generated from "Export -> Forward Engineer SQL CREATE Script..." always has a database name prefix on every table. We will have to manually remove this every time we create the SQL script. It would be great to have an option to leave the database name out of the generated script.

How to repeat:
Create any schema with one or more tables, and export a SQL CREATE script.
Note that every table has the database name prefixed to it.

Suggested fix:
Add an option to the "Export -> Forward Engineer SQL CREATE Script..." to leave off the database name.
[10 Sep 2008 1:05] MySQL Verification Team
Thank you for the bug report.
[10 Sep 2008 8:32] Johannes Taxacher
this is a very reasonable feature request, but it won't make it into 5.0 anymore. 
So i've taken the liberty of changing your submission to vesion 5.1 and S4 (feature request) so we have it on our list for version 5.1

thank you
[8 Feb 2010 11:48] Johannes Taxacher
This issue has been fixed in the latest released version of that product, which you can download at
http://www.mysql.com/downloads/