Copy and Paste Tables/Databases/Functions/Views
It would be nice to be able to copy and paste Database's,Tables, Functions and Views like MySQL Front did. I know you have your table clone tool, but tables are not the only asset I think this radical idea should be applied to.
I am running MySQL-Front 5.1 Build 3.73, last Version ever released. In this version, I can right click copy and paste, database's, tables, functions, views. I can even do it across servers. I have downloaded the trail version which I can email to you, or tell you the link to download so you can see the SQL its running if you like. I would like to move completly over to heidi, however as you have seen from my posts.. some features which I rely on daily from MySQL-Front are missing in heidi. So I continue to use both (MySQL Front when it doesn't crash), and heidi for all the things it does much better than MySQL Front.
Sorry again, I was trying to save time and give you a core location to find the information.
You already present an option to clone table. You already know how to step over the whole a whole database. You already know how to read a view. you already know how to read a function.
You also know how to create tables, views, triggers, databases.
You also know how to read columns.
From your clone table feature you normally add '_copy' on the end to avoid conflicting names.
So when a users selects copy, store what it is they want to copy (a ref to a type of object and what the object is)
when they click paste, step over what ever the object was (so a database would be a lot of work to step over, a function would just be one object) then use the create syntax to create it in the destination.
Im not 100% on the technical data of copying data, but maybe a select insert?
You already present an option to clone table. You already know how to step over the whole a whole database. You already know how to read a view. you already know how to read a function.
You also know how to create tables, views, triggers, databases.
You also know how to read columns.
From your clone table feature you normally add '_copy' on the end to avoid conflicting names.
So when a users selects copy, store what it is they want to copy (a ref to a type of object and what the object is)
when they click paste, step over what ever the object was (so a database would be a lot of work to step over, a function would just be one object) then use the create syntax to create it in the destination.
Im not 100% on the technical data of copying data, but maybe a select insert?
Please login to leave a reply, or register at first.