When I changed my job I also switched from Microsoft .NET world to IBM, Oracle and Suns world. I was familiar with SQL Server 2000, 2005 and their Management Studio. Management Studio is OK and you can do most things there. In my new environment I was faced with Oracle, DB2 and MS databases and all of them have their own clients. First of all when I saw Oracle SQL+ -disaster - productivity 0.
I was forced to find some kind of universal client and I found this great
SQuirreL Universal SQL Client. It is free and open source. You can use it with any databse which have available JDBC drivers.
Most important features for me:
- Code completion (intellisense)
- Editing of SQL results
- SQL queries history
- ...
There are also a lot of plugins available:
- SQL scripts
- Syntax Highlighting
- Refactoring Plugin
- Data Import Plugin
- DBCopy Plugin
- ...
Useful links