SQL export allows output to be piped to disconnected sessions
| User, date | Message |
|---|---|
|
Written by superspace
3 months ago Category: General 22 posts since Mon, 28 Aug 06 |
I've just noticed that in the current version (7.0.0.4350) of heidiSQL (and introduced sometime in the past), it's possible to export data to a disconnected session. I think this is dangerous. I disconnect my production session when not in use, but to see it in the list of candidates for my export in my dev session, is disturbing. What are your thoughts? |
|
Written by ansgar
3 months ago 3966 posts since Fri, 07 Apr 06 |
I'm not sure why you think you need to be connected to session you want to export to something. HeidiSQL's export dialog does not make use of your connected sessions. Instead, when you select a target session, the dialog creates its own session for exporting. That way, exporting is totally independent of the opened sessions in HeidiSQL. |
|
Written by superspace
3 months ago 22 posts since Mon, 28 Aug 06 |
Well a long time ago you had to create two HeidiSQL windows (with diff sessions) to export data from one to the other. Re-visiting this feature today, I found you don't need to have the session open to export data (just as you had described). I believe exporting *should* be dependent on opened sessions. That way limiting accidental export to a production DB, for example. |
|
Written by superspace
3 months ago 22 posts since Mon, 28 Aug 06 |
Some options that could be implemented easily (i think) to mitigate this: * Tick box to display only connected sessions * Bold connected sessions and order them on top of disconnected sessions |
|
Written by ansgar
3 months ago 3966 posts since Fri, 07 Apr 06 |
Sorry, no go. That would again add an artificial limitation we had before, but noone wanted! The connected sessions have nothing to do with the target to where you want to export. Even making connected sessions bold is not possible in a combobox. |
|
Written by kalvaro
3 months ago 442 posts since Thu, 29 Nov 07 |
I've created folders in my session manager to tell apart development and production sites. Those folders show up in the "Output" combo: Server: Development\Acme Inc. I works quite well for me. |
|
Please login to leave a reply, or register at first. |