#67 Export Aliases and Drivers

open
nobody
None
5
2014-08-21
2003-06-20
KosherJava
No

Hi,
In the last few days a number of co workers who have
seen me using SQuirreL have installed it. What I found
to be the hardest part of the setup was getting the
drivers working and configuring the DB to work.
What would be nice were say the ability to export my
list of aliases (minus user name and passwords) and
actual drivers in 1 jar file that could then be
imported into any other SQuirreL client. This would
also east the setup of SQuirreL in enterprize settings
where the help desk could just supply a preconfigured
"settings" jar that would be easily imported. I
understand that you cant supply the JDBC drivers but in
a case where the user had licensed drivers, repackaging
them for internal distribution makes a lot of sense.

I think this would greatly enhance the usability and
"market share" of SQuirreL

Discussion

  • Acid Rain

    Acid Rain - 2004-06-04

    Logged In: YES
    user_id=1056602

    It's not too difficult to do this manually.
    If you have a look in the directory where SQuirreL saves its
    settings (under WinXP this is "%USERPROFILE%\.squirrel-sql",
    I'm not sure what it is on Linux, but I'd guess it's something
    like "$HOME/.squirrel-sql"), you'll find a few .XML files which
    contain all your settings. It should be pretty obvious which
    file contains what. All you'd need to do is modify these (to
    remove the username & password) then distribute to your co-
    workers. The only thing you need to worry about then would
    be the actual drivers. If you put them on a shared drive
    though, it should be pretty easy.

     
  • Nobody/Anonymous

    Logged In: NO

    I have had squirrel drop my aliases many times. Reloading
    them is not fun. I think that this feature would be mighty
    useful. I actually came to the page to suggest the same
    thing.

     
  • Nobody/Anonymous

    Logged In: NO

    I'd like a similar feature, or the option of specifying the configuration directory, for the quite common situation nowadays: I'm transporting Squirrel on an USB stick and looove selfcontained apps.

     
  • Rob Manning

    Rob Manning - 2007-06-11

    Logged In: YES
    user_id=1287991
    Originator: NO

    There is an export plugin but it only copies the relevant files to a different location on disk. I've thought in the past that it should also allow you to import these exported files. It needs a little work to become truly useful, so I've not thought to include it in the installer. I could be persuaded to include it if folks think it would be useful in it's current state.

    In response to:

    "I'd like a similar feature, or the option of specifying the configuration directory, for the quite common situation nowadays: I'm transporting Squirrel on an USB stick and looove selfcontained apps."

    You may configure SQuirreL to retrieve/store preferences from a specific location by passing
    "-userdir" or "--user-settings-dir" arguments on the command-line (in squirrel-sql.sh or squirrel-sql.bat)

    In response to:

    "I have had squirrel drop my aliases many times. Reloading them is not fun. I think that this feature would be mighty useful. I actually came to the page to suggest the same thing."

    We haven't had a report of this issue since early 2.3 releases. I think we fixed the problem causing this in either 2.3.1 or 2.3.2. You should upgrade to the latest version and report a bug if you are still losing all of your aliases.

    Rob

     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks