May 16, 2006 at 11:21 pm
Hi all,
Could you guys please suggest query tool which is most popular among the community other then Query Analyser and a brief note on why it is better.
Regards,
May 17, 2006 at 7:32 am
First, you need to supply some more information.
How is this query tool going to be used? Will it be used by the DBA, developers, or users?
Why not Query Analyzer?
What does the tool need to do? Does it need to just query the database? Does it need to also create reports?
-SQLBill
May 17, 2006 at 3:10 pm
When not using QA, I happen to like ApexSQLEdit.
K. Brian Kelley
@kbriankelley
May 17, 2006 at 10:11 pm
SQLBill,
We need alternate to QA because we also need to query DB2. The tool will be used by developers and entry level DBA. Maily tool will be use for querying database but if it does reporting and exporting data in differenct formats and few more goodies (stuff that QA doesn't do) then that is the tool ideal for us.
Hope, that answers your questions.
Regards,
Roshan
May 18, 2006 at 6:10 am
Ah...like I said, MORE information. You need a query tool that will work with more than one type of database, specifically SQL Server and DB2.
I don't know of any and I'm not familiar with DB2.
-SQLBill
May 18, 2006 at 6:26 am
QueryToDoc (http://www.querytodoc.com) is kind of interesting. It lets you query SQL Server and Oracle databases. It limits queries to Select statements and outputs the results to a Word document or an HTML file.
May 18, 2006 at 6:32 am
I found below tool and have use it today and I am impressed.
Advanced Query Tool
Try it and let me know your opinion.
May 18, 2006 at 7:57 am
I have been very happy with dB Visualizer:
May 18, 2006 at 2:22 pm
AquaFold DataStudio.
Of course, I work for an educational institution, so the license is free.
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply