Post reply

Development IDE for SQL2K - suggestions?

  • March 29, 2004 at 12:26 pm

    #84656

    Does anyone have any good suggestions for "alternate" IDE's for developing SQL Server objects and code? I like Query Analyzer OK, but occasionally miss some of the functionality I used to get with the TOAD software for Oracle, or even some of the nice things that VS.Net includes, like collapsable regions within code.

    Now that my job is finally 110% SQL Server (yay!), I've been looking for different options for T-SQL development, but haven't really found anything remarkable just searching through Google. Any suggestions would be appreciated. Thanks!

     

  • March 29, 2004 at 2:55 pm

    #500954

    I used Visual Interdev 6 and now use Visual Studio .NET 2003.  I like the environment.

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • March 29, 2004 at 10:39 pm

    #501006

    I use QA most of the time but have used SQL Programmer from BMC in the past. They have a freeware version that will do the majority of what would be required. I also understand Toad has a SQL version available now though I have not tried it yet.


    Trevor Hampson
    DBA

  • March 30, 2004 at 6:15 am

    #501053

    You should take a look at http://www.mssqled.com.  This is a really nice IDE that does most of what Query Analyzer does, and many things that QA doesn't do.  The Intellisense (auto-complete) on table names and column names as you write queries alone made it worth the $15 price to me.

  • March 30, 2004 at 6:17 am

    #501054

    TOAD has now put out a comprehable product for SQL Server.... You can find it for download at http://www.toadsoft.com/toadss.html . Like the original TOAD - Don't know how long it will remain free.

     

     

  • March 30, 2004 at 2:45 pm

    #501182

    SQL Server Development IDE's.

    Xpress Apps have by far the best one, some of the biggest development houses use this one.

    http://www.xpressapps.com/

    Regards

    Douglas Chrystall

    Imceda Software, Inc

    http://www.imceda.com

     

     

  • March 30, 2004 at 2:57 pm

    #501188

    I downloaded Toad for Sql Server and was not impressed with the interface, but it does have a lot of features.  I also tried msSqled which is excellent.  You can use it for free but it has an annoying pop-up that comes up after a certian # of executions.  It is only $15 to register and eliminate the pop-up.  IT also integrates with Reporting Services so you can create reports by right-clicking in the query window and slect Create SQL Reporting Service Report it is basic, but you can define templates to use. 

    Jack Corbett
    Consultant - Straight Path Solutions
    Check out these links on how to get faster and more accurate answers:
    Forum Etiquette: How to post data/code on a forum to get the best help
    Need an Answer? Actually, No ... You Need a Question

  • March 30, 2004 at 3:01 pm

    #501193

    Thank you all for your very interesting suggestions. I'm enjoying trying out mssqled, toad for SQL and may give the xpressapps application a try, but I'm a little wary of the server component on that one.

    So far my favorite of the 2 I've been toying with is mssqled, I especially appreciate the quick response on bug reports and enhancement requests. It's a very interesting project. But I'll also try to take a look at the xpressapps IDE as well, it looks like it has a very impressive feature set.

     

  • March 30, 2004 at 3:08 pm

    #501196

    I started using Visual Studio for SQL Dev work about 6 years ago and now I don't use anything else. My reasoning is that no matter what job I had at the time I always had a version of Visual Studio on my machines. Using a database project allows me to easily keep my scripts in source control plus I have the direct access to the databases as well. I also have a VERY powerful macro language that I use a lot. One of my favorite features is automated creation of command files for a directory. This makes deployment of my scripts very easy!




    Gary Johnson
    Microsoft Natural Language Group
    DBA, Sr. DB Engineer

    This posting is provided "AS IS" with no warranties, and confers no rights. The opinions expressed in this post are my own and may not reflect that of my employer.

  • March 30, 2004 at 3:23 pm

    #501201

    I use DBartisan from http://www.embarcadero.com  Really great product but unfortunately not cheap.

Viewing 10 posts - 1 through 9 (of 9 total)

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