Friday, 19 June 2009

SQuirreL SQL Client: how to save your connection alias list

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

1 comment:

  1. Great, this works. I found on it on C:\Users\[user]\.squirrel-sql\SQLAliases23.xml

    ReplyDelete

Live Traffic Feed

 

Be notified of
page updates
it's private
powered by
ChangeDetection

Copyright © 2008 HandyTechTipper. All articles are released under the Creative Commons Attribution 2.5 South Africa license, unless where otherwise stated.