Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Connection settings in a database

Skelgaard's profile image Skelgaard posted 7 months ago in Feature discussion Permalink

It would be so nice, if the connection data could be stored in a database instead, so that my 3 machines could be in sync with the connections....

and i bet alot of other users could use this too :)

Skelgaard's profile image Skelgaard posted 1 month ago Permalink

no replies to this one :(

ansgar's profile image ansgar posted 1 month ago Permalink

Well that's the way it is currently, and your post did not contain a question.

However, you could download the portable version and sync the portable_settings.txt file with your other machines.

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
Skelgaard's profile image Skelgaard posted 1 month ago Permalink

yes but that would make me have to setup a shedule on two/more machines to do this automatic to sync several machines to same connections. And if then changed on both machines at once, then it gives conflicts and so. Thats why a sql save function would be better.

That will also make that if you work with more teams, you can have a db for each team and connects shared with them, if multible "groups" could be added with connections and each group could have its own connection save point...

ansgar's profile image ansgar posted 1 month ago Permalink

Honestly, that's nothing I would implement in HeidiSQL. Security is also an issue here, as the session settings contain credentials, which you then would share through a database. I would not like to be responsible for such issues, as the developer of it.

But you could set up such a workflow yourself, with some external tools, it should be possible to have the settings in a database. E.g. instead of starting heidisql.exe, you could write a heidisql.cmd batch file, wich exports settings from your database using mysqldump, and then start heidisql.exe.

Skelgaard's profile image Skelgaard posted 1 month ago Permalink

If security of the sql is an issue, then you proberly have a bigger problem as there generaly would be a bigger chance that your workstation will be hacked than your sql.

Problem with the suggested sollutions is merge bug and only getting stuff updated on close, not live, so if i change something on one computer, the other doesn't see it.

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