Aqua Data Studio

Seems like I've been blogging a lot about new tools lately but here comes another one.  I was recently informed about Aqua Data Studio by one of my co-workers and when I read about it I had to try it.  I installed it this morning and have been playing around with it and I must say I'm extremely impressed.  Anyone who has used Enterprise Manager and Query Analyser for MS SQL will find it very familiar.  What blows me away is that you can manage MS SQL, MySQL, PostgreSQL, Oracle, the  list goes on and on, all in one interface with the same look and feel across dbs.  Not only that, you can install it on Windows, Linux, and Mac OS X and have the same tools with the same interface on any or all of these platforms.  Its free for personal/educational use and reasonably priced for commercial use at $149 per user.

I installed it both on a Windows machine and on a Suse 9.2 machine.  Its very nice having the same interface on both platforms and now I can manage MS SQL, Postgre SQL , and MySQL using the same interface on either machine.

Another interesting feature that I haven't seen elsewhere in SQL tools is the intellisense like statement completion. It gives you a drop down list of table names while you write a SELECT statement!