Bite my bytes

What I learn by day I blog at night - A blog from Microsoft Consultant working from Ljubljana, Slovenia

  Home :: Contact :: Syndication  
  999 Posts :: 7691 Comments :: 235 Trackbacks


Most popular posts
in last 90 days


My Projects



Copyright © by David Vidmar
Contact me!
LinkedIn Profile

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?

Posted on Thursday, January 27, 2005 11:10 PM | Filed under: Developement |


# re: Aqua Studio - my new Query Analyzer substitute? 1/28/2005 8:42 AM Miha
We have tested and did find the tolls very useful but unfortunatly they are not for free ;-)

# re: Aqua Studio - my new Query Analyzer substitute? 1/29/2005 11:27 AM Mark
I have installed on my winblows macine. But when I work on PostgreSQL and MySQL I more or less connect through SSH and do my thing in the shell client. So I haven't really tested the dbVisualizer and don't know if it has the auto completion function. Maybe just the free version doesn't support it. I did find out that multiple queries can't be executed at once (at least in the free version). :/

# re: Aqua Studio - my new Query Analyzer substitute? 1/30/2005 9:14 PM David
Both look cool. Apex is way too expensive, DBvis is actually very similar to Aqua studio.

Thanks for the links, I appreciate it!

Comments have been closed on this topic.