SQuirreL SQL Client is a great graphical Java program... but setting it up on a new PC (or a colleague's) can be tedious.
So, HTT went behind the scenes (the Windows scenes) to see where it stores the alias connection info.
Using FileMon the file's location was found to be in your 'Documents and Settings' folder eg: "c:\Documents and Settings\HTT\.squirrel-sql\SQLAliases23.xml"
So, save that file and give it to your colleagues or new laptop and that should save you a lot of time.
BTW: if you use mySQL, then here's another great SQL client: SQLyog
There's even a 'Community edition' - see here for the differences: Compare Enterprise vs. Community
Great, this works. I found on it on C:\Users\[user]\.squirrel-sql\SQLAliases23.xml
ReplyDeleteIf you are having issues saving the aliases it's because you aren't shutting squirrel down properly. In my case i always kept it open until i switched off my laptop. By doing this the trigger to update the XML files saving the aliases never updated. Just be sure to close the application before switching off your machine when you've added a new alias or driver.
ReplyDeleteThe answer is correct by "UnknownTue Oct 16, 12:47:00 pm GMT+2". I did exit with File option and the alias saved in the SQLAliases23.xml file correctly
ReplyDelete