Bug #55196 Ability to move tables between schemas
Submitted: 12 Jul 2010 22:18 Modified: 30 Jun 2011 9:58
Reporter: Jeremy Tinley Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench: Modeling Severity:S4 (Feature request)
Version:5.2.25 CE OS:Windows (7.0)
Assigned to: CPU Architecture:Any

[12 Jul 2010 22:18] Jeremy Tinley 
Description:
Request for the ability to move tables between databases, specifically with a drag and drop motion, but Cut/Paste (especially multiple) would be feasible.

How to repeat:
From the Model Overview window:
* You cannot drag and drop a table to a new database.
* You cannot cut/paste to the new database.
* You cannot select multiple and copy/paste.

The workaround is to copy the table, paste it in the new database, then delete the original.  While feasible, it is time consuming.

Rationale:
This action can be performed from the database by using RENAME TABLE or ALTER TABLE very simply.  I suggest that it be equally simple in Workbench.

Suggested fix:
Code the necessary functionality to be able to drag and drop a table from one database to another.
[13 Jul 2010 22:21] Jeremy Tinley 
Correction:  Cut/Paste between two databases does work eliminating the need to copy and delete.
[30 Jun 2011 9:58] Jon Stephens 
Duplicate of BUG#53040.