Development IDE for SQL2K - suggestions?
-
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!
-
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 -
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 -
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.
-
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.
-
SQL Server Development IDE's.
Xpress Apps have by far the best one, some of the biggest development houses use this one.
Regards
Douglas Chrystall
Imceda Software, Inc
-
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 -
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.
-
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 EngineerThis 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.
-
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