Recommendations for a Query Analyzer replacement

  • We're looking for a good tool to replace QA, hopefully soon! Anyone have any receommendations or experience with any good 3rd party tools? Thanks.

    Frank-

  • What are you looking for a replacement for?  i.e.  What features are you wanting that QA doesn't provide?



    Good Hunting!

    AJ Ahrens


    webmaster@kritter.net

  • Hi Frank,

    It would be worth your time to investigate our ApexSQL Edit product.

    http://www.apexsql.com/sql_tools_edit.htm

    Apex SQL Tools has started a blog to list development progress of Apex SQL

    Edit, SQL Database Tool for SQL editing. Apex SQL Edit is a SQL Tool

    integrated development environment (IDE) for SQL Server including powerful

    SQL Database development capabilities, updated GUI, Command Line,

    Intellisense, integration with Visual Source safe, collapsing regions, SQL

    formatting and more. Free support and free product upgrades for life.

    http://apexsqledit.blogspot.com/

     

    Todd Monjar

    Todd Monjar
    ApexSQL - Value added SQL tools
    todd@apexsql.com
    http://www.apexsql.com

  • I have been using ApexSQL Edit for several months.

    It has some very handy additions that make writing sql easier (such as intellisense).

    There are still times that I use QA, but they are usually when I must generate standard INSERT/DELETE or UPDATE sql for a table, procedure or function and then I copy/paste that into ApexSQL Edit to manipulate it.

    Quand on parle du loup, on en voit la queue

  • As AJ has said, What features are you wanting that QA doesn't provide?

    There are quite a few editors out there,

    - the afforementioned ApexSQLEdit

    - SQL IDE from Imceda http://www.imceda.com/SQL_IDE_Description.htm

    - for SQL 2005 products there is http://www.tegels.org/qara/

    --------------------
    Colt 45 - the original point and click interface

  • http://www.yohz.com is worth a visit.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • Thanks Frank, another one to add to the list

     

    --------------------
    Colt 45 - the original point and click interface

  • If you'd like to stick with Query Analyzer then you might want to check out PromptSQL which adds SQL Intellisense-like autocompletion to QA:

    http://www.promptsql.com/

     

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply