distal-attribute
distal-attribute
distal-attribute
distal-attribute

Modify table on multiple sessions at once

User, date Message
Written by roblambell
7 months ago
Category: Feature discussion
4 posts since Wed, 26 Feb 14
The ability to save changes to a table/database on multiple sessions (to database of the same name) at once would be fantastic.

For example, amending/adding columns and having the option to Save changes and also "Save to Server: .."

smile
Written by jfalchMoney, Euro
7 months ago
412 posts since Sat, 17 Oct 09
each change that you make to a table structure is always "saved to server" when you click "save". (where else could it be saved?)
Written by roblambell
7 months ago
4 posts since Wed, 26 Feb 14
It could be saved to another session with a database and table of the same name.

I was referencing the language used in the "Output:" field of the "Export database as SQL" dialog.

One possible implementation would be in the style of a split button, then listing the "Server: " options as shown in the referenced dialog.

This would save time when needing to quickly make a change to multiple versions of a database.
Written by roblambell
7 months ago
4 posts since Wed, 26 Feb 14
This type of button is used for example in the bottom left of the Session manager dialog.

There may certainly be a more intuitive way of making this type of functionality available, or something I have overlooked.

I'm imagining the Save button component to work with the main button as the existing Save function, whilst the drop down element allowing the changes to be Saved to the current table structure and be applied to another that is selected.

This would only allow the changes to be applied to one other session.

This same result could be achieved too if for example the queries in the query log could be executed on another session from the context menu.

The way I do this currently involves finding the database in the other session and making the same change through the editor or running the query there too. With many databases listed I find myself running multiple instances of HeidiSQL, one for each session, but it is simple repetition.
Written by jfalchMoney, Euro
7 months ago
412 posts since Sat, 17 Oct 09
so, you do not primarily want to save to another session, but want to replicate changes in a databases table structure to another database (possibly on another host) which has a similar table ? if so, I suggest you open a feature request about this.

NB: the queries in the query log cannot currently be re-executed by context menu alone. but it is possible to copy them to a new query tab via a context menu entry, and then execute them from there after changing the session.
Written by roblambell
7 months ago
4 posts since Wed, 26 Feb 14
That's right. Thanks, I've created an Enhancement issue

https://code.google.com/p/heidisql/issues/detail?id=3523
 

Please login to leave a reply, or register at first.