Category: Database
License: LGPL
Website: http://www.sqlexplorer.org/
Description: Eclipse SQL Explorer is a thin java based SQL client that allows you to query and browse any JDBC compliant database. It supports plugins with specialized functionality for individual databases (Oracle, DB2 and MySQL) and can be extended to include specialized support for other databases.
The application that I am currently engaged with connects to numerous different database servers. Every time there was a requirement to connect to a new database server that was not already supported by my app, I was forced to install a compatible client to query the DB. I had to go through the painful process of getting approvals, raising all the necessary tickets, following up with all the concerned parties, are just some of them. These are circumstances when you start questioning yourself “There is got to be a better way of doing things?”
Necessity is the mother of all invention, luckily in my case I didn’t have to invent anything. A little bit of googling did the trick. That’s when I was introduced to SQL Explorer. I used the standalone version and it worked like a charm. I could connect to all the servers that I needed to, in a single IDE. I could connect to SQL Server, Sybase and Oracle in a familiar looking Eclipse IDE. Some of its impressive features are
1. Exporting query results to html/csv/xls formats
2. Stores all the queries run successfully. These can be easily searched or filtered.
3. Saves all DB server connects, you can check the option to reconnect on start up.
4. Database explorer to view all objects created on the database
The SQLExplorer will humble an arrogant SQL Server Client or any other paid client out there. I would strongly recommend SQLExplorer.
Cost Comparison of other SQL Clients TOAD: $595.00
“A Penny Saved is Worth More Than a Penny Earned”
Friday, March 5, 2010
Subscribe to:
Posts (Atom)
