You are here

SQL Query Tool - Any Recommendations ?

9 posts / 0 new
Last post
RossGoodman
Offline
Last seen: 2 years 9 months ago
Joined: 2005-12-19 12:51
SQL Query Tool - Any Recommendations ?

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

Rob Loach
Rob Loach's picture
Offline
Last seen: 15 years 7 months ago
Developer
Joined: 2005-12-09 17:29
Nice Tool

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]

jimjams
Offline
Last seen: 17 years 2 months ago
Joined: 2005-12-12 04:56
Java

Java based:

www.aquafold.com
they have a free version, works very well

works fine with my JRE installed on usb mem

JackT
Offline
Last seen: 17 years 7 months ago
Joined: 2005-12-10 10:17
What I usually do for MySQL

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.

RossGoodman
Offline
Last seen: 2 years 9 months ago
Joined: 2005-12-19 12:51
PERFECT !!!

PERFECT !!!

AquaFold gives me much more that I was looking for !
portable, free and LOTS of features !!!!

GadgetGirl (not verified)
SquirrelSQL

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

Deuce
Offline
Last seen: 13 years 6 months ago
Developer
Joined: 2005-12-24 16:32
Portable JAVA JRE????????

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.

John T. Haller
John T. Haller's picture
Online
Last seen: 59 min 27 sec ago
AdminDeveloperModeratorTranslator
Joined: 2005-11-28 22:21
It can

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!

GadgetGirl (not verified)
Yeah...

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.

Topic locked