I want to query a number of different databases mainly Oracle and Informix. Can anyone suggest me some tool using which I can do this easily?
+2
A:
I like SQuirreL SQL Client. It's cross platform and database independent, and quite handy.
erickson
2008-08-29 05:36:11
+4
A:
Try WinSQL lite at http://www.indus-soft.com/SynametricsWebApp/WinSQL.jsp. It is absolutely free and does not expire. It is only one file and does not come with any bulky DLLs. If you don't like it, simply delete the file from your hard drive.
An introduction about how to use it against an informix database can be found in this article.
Espo
2008-08-29 06:05:58
A:
@littlegeek: Toad is not available for Informix. Additionally, the OP seems to want a single program that can query several different brands of DBMS, and you have to buy a different version of Toad for every DBMS you want to use it with.
crosstalk
2008-08-29 06:30:27
A:
Informix is not very well supported among third party database tool vendors.
Interestingly, Oracle' SQL Developer supports browsing (and converting to oracle) several databases, including SQL Server and MySQL.
Mark Harrison
2008-08-29 06:36:45
A:
Try the following:
- Query Express (single 100KB executable, no install)
- Query ExPlus (improved Query Express)
John
2008-08-29 06:48:50
+1
A:
As a previous answer stated, WinSQL is one of the best "generic" sql query programs, although it is far from perfect. Generally speaking, the programs dedicated to a particular sql product are better (usually 3rd party products, not written by the SQL vendor). TOAD is a great program for Oracle (originally written by an Oracle employee in his spare time before being bought by Quest). TOAD has become a little bloated of recent versions, but is still a fantastic product. I think there are versions of TOAD for MySQL and maybe one or two others, however, the Oracle version is by far the best. When I last used Informix (2004) there was a reasonable 3rd party Java program whose name escapes me for the moment. The standard tools that come with Informix are from the dark ages (I used the Unix utilities that look a bit like DOS versions of Lotus 123), so anything else is better. I used WinSQL with Informix with great success.
Mike Thompson
2008-08-29 08:36:50
A:
There is several options on this page: http://freewarehome.com/index.html?http%3A//freewarehome.com/bx/index.php%3Faction%3Dvthread%26forum%3D8%26topic%3D7136
GenDAT is not bad, but I am biased as I did write it ! It has been voted highly though.
I need cross platform now so I use Oracle SQL Developer which I think is great. It can handle other databases not just Oracle. Another good one (cross platform) is DB Solo.
stevechol
2008-09-04 10:53:55
A:
Nob hill's query tool is something else.. you can get Data From Any Source: SQL Server, Oracle, MySQL, CSV or fixed-width text files, XML files, ADOMD sources (cubes) or and many other OLEDB or ODBC-based data sources.
Complex search criteria can be defined to find your needle in a hay stack. Full regular expression support.
And theres an option to monitor changes..
Itamar
2009-03-24 15:17:50