Post reply

Any alternatives to Query Analyzer?

  • July 30, 2003 at 5:37 am

    #80765

    Just curious at the moment, but are there any other options out there for writing SQL code besides using Query Analyzer? Anything that would be worth trying?

  • July 30, 2003 at 6:14 am

    #467701

    Have a look at mssqlxpress. It's a bit like QA with some additional features like VSS integration.

    http://www.xpressapps.com/

    [font="Verdana"]Markus Bohse[/font]

  • July 30, 2003 at 8:12 am

    #467744

    DB Artisan is very good for writing SQL, and works for Oracle, Sybase, etc. too.

    http://www.embarcadero.com

  • July 31, 2003 at 8:21 am

    #467993

    I use DBArtisan myself but it is rather expensive. I believe the less expensive version is RapidSQL but I think it is sold only for specific databases as opposed to DBArtisan which, like Katy points out, supports several platforms.

  • July 31, 2003 at 8:48 am

    #468005

    what about SQLEXECMS, it works pretty well for me and the price is right.

    http://www.laplas-soft.com/exec-intro.htm

  • July 31, 2003 at 9:29 am

    #468024

    I think mssqlExpress is the most attractive for me. I'm giving it a shot now. So far it's pretty nice!

  • July 31, 2003 at 9:47 am

    #468033

    Out of curiostiy, why do you all choose to use another product other than Query Analyzer? Does the other software offer any features better than in QA which would help people like me who are still new to SQL Server and T-SQL? So far I have not tried anything else, though can see the obvious benefit of having VSS integration.

  • July 31, 2003 at 9:52 am

    #468036

    There are many features, such as autocomplete and script libraries, that come in handy when you write alot of scripts. I write scripts everyday so this is going to help me out alot.

  • July 31, 2003 at 10:00 am

    #468040

    Guys.. for me i really like using Visual InterDev 6.0 with VSS intergration. i can debug and step thru procs and query tables.. and everything i need...

  • July 31, 2003 at 10:04 am

    #468041

    I will have to give mssqlxpress a go then. Autocomplete functions can be a really good way to build up your skills (as well as saving time and keeping down the number of errors).

  • July 31, 2003 at 11:00 am

    #468056

    in risc of getting flamed:

    Are any of those tools available on other platforms as Windows ? (Linux, Mac OS X)

    Thanks

  • July 31, 2003 at 11:32 am

    #468061

    quote:

    in risc of getting flamed:

    Are any of those tools available on other platforms as Windows ? (Linux, Mac OS X)

    Thanks

    Yes, I think that the second one mentioned is.

  • July 31, 2003 at 11:39 am

    #468063

    quote:

    Guys.. for me i really like using Visual InterDev 6.0 with VSS intergration. i can debug and step thru procs and query tables.. and everything i need...

    How does that compare to using Query Analyzer or mssqlXpress?

  • July 31, 2003 at 12:40 pm

    #468079

    i cant compare it to xpress BUT if its between QA and InterDev, i like InterDev for the simeple fact that i can STEP thru my stored procc line at time AND interdev interface is directly tied to VSS and interdev has color codeing of code from command syntax to datatypes. AND it comes with my MSDN. but then again as most can say, everyone has there fav editor...

  • August 1, 2003 at 8:32 am

    #468229

    Try http://sqlbuddy.sourceforge.net/

    It is a freeware that is cool...

Viewing 15 posts - 1 through 15 (of 15 total)

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