Hi
Can anyone recommend a:
generic,
free,
open source
and preferably portable
SQL Query tool that can connect to ideally:
Oracle
SQL Server
MySQL
I understand that true portability will be limited as the middleware and configuration will have to be on the desktop, but it would be nice to just plug and play in the same way that I do with my other apps.
Ross
Visit the Community page
Join our forums
Subscribe to our email newsletter
Subscribe with RSS
Follow us on Facebook
Follow us on LinkedIn
Follow us on Twitter
Follow us on Mastodon
Follow us on BlueSky
An SQL Query tool would be a nice thing to have. I'm currently only using Visual Studio 2005's SQL stuff.
Rob Loach [Website] [Projects]
Java based:
www.aquafold.com
they have a free version, works very well
works fine with my JRE installed on usb mem
What I usually do for MySQL is (from my MySQL installation on my machine) copy mysql.exe from MySQL\bin and run it through a batch file:
mysql -h{host} -u{root} -p{password}
Not sure about Oracle or SQL Server, but this is what I use for MySQL.
PERFECT !!!
AquaFold gives me much more that I was looking for !
portable, free and LOTS of features !!!!
My personal favorite, and one that is always on my USB drive is SquirrelSQL (http://squirrel-sql.sourceforge.net). It is a Java app that will connect to most every RDBMS that has a JDBC driver. The one minor "gotcha" is that you may need a portable copy of the Java JRE, which isn't hard to do. SquirrelSQL comes with both *nix and win32 startup scripts that can be modified slightly to keep the program settings confined to your USB drive, and set a path to the Java JRE on your USB drive.
For example, I made the following change to the squirrel-sql.bat file:
SET TMP_PARMS=--log-config-file "%SQUIRREL_SQL_HOME%\log4j.properties" --squirrel-home "%SQUIRREL_SQL_HOME%" %1 %2 %3 %4 %5 %6 %7 %8 %9
to
SET TMP_PARMS=--user-settings-dir "%SQUIRREL_SQL_HOME%\.squirrel-sql" --log-config-file "%SQUIRREL_SQL_HOME%\log4j.properties" --squirrel-home "%SQUIRREL_SQL_HOME%" %1 %2 %3 %4 %5 %6 %7 %8 %9
Could you possibly tell me how you got JAVA to be protable???? In my testing, John's and most of the users on this forums, Java cannot be made portable because of the registry entries it needs to function.
Would be an interesting thing to know, if you don't mind...
Deuce
"Portable Software: Just the beginning..."
Deuce
Portable Software: Just the beginning.
You just have to point it to the right files. It can work fine with JARs. Just not with something like Portable Firefox.
Sometimes, the impossible can become possible, if you're awesome!
It's true that that you need registry settings to allow things like the Java plugin for browsers to work. However, the java executable and the supporting files are portable if invoked from a command line or batch/shell script. So, for things like the SquirrelSQL startup script, you can reference your JDK dir on your usb drive, make sure the classpath is set to include the correct jars, and it is portable.
In my first post, I mentioned the JRE... Typically, I only ever include a copy of the JDK directory on my USB drive. I'm not sure if making copies of the JRE directory on your USB drive will work just as well, but I don't see why not. The java executable from the JRE or JDK should run fine from the USB drive from the command line or from a batch/shell script.