I have been looking for a SQL Query Analyzer / Enterprise Manager substitute for a long time. I use SQL Query Analyzer all the time, usually I have open two or three, one for each database I'm working on. It a nice tool, quick and snappy, but I could really use auto-complete for column and table names. I write MarketFinancialInstrument at least 50 times a day and it's REALLY annoying. Compared to modern editors it's so 1990s... And once you have tried or just seen PL/SQL Developer, you have trouble settling for less.
I had great hopes of SqlBuddy, but unfortunately it's been dead for a while...
Today Stefano Emiline blogged about Aqua Studio and I was stunned. Could this be it?!
I installed it, but it will take couple of days before I can say if this is it.It has nice auto-complete capabilities, you can register servers and organize them in a tree and many other cool features. And it's not just for MS SQL Server, it supports all major databases. It's Java based and it has really friendly licensing plan.
The bad part is that it's quite ugly and not very Windows-like, which I don't like. Also, toolbars occupy way too much space. But if everything else works as it should I think this could be a winner.
Do you know any other tools like this?