Just curious if there are better tools out there for sql server development. We currently use the standard MS stack . . . SSMS with the addition of Redgate's SQL Prompt (which rocks...most of the time).
Are there others? Are there better tools?
+3
A:
TOAD for SQL server
Also a list here: http://www.sqlserverportal.com/software/development/development.htm
SQLMenace
2008-08-22 16:57:30
+2
A:
I've just used Enterprise Manager for MSSQL2000 and now SQL Server Management Studio for MSSQL2005.
Zack Peterson
2008-08-22 17:01:32
A:
I like 2008's SSMS. The editor appears to be based on Visual Studio 2008 now, instead of whatever it was in SSMS 2005.
Dave Ward
2008-08-23 17:27:53
+1
A:
I like aqua studio, and being multi platform your whole team can use it.
BigMadKev
2008-08-23 17:31:11
A:
Emacs.
The main reason being the powerful text editing features for manipulating your TSQL code which I found severely deficient in SSMS 2005 (yet to use 2008). You can connect and run/test your code against a database from within Emacs.
However, if you are someone that prefers a "pretty" GUI-heavy IDE environment then Emacs might not suit you.
Ray Vega
2008-09-12 16:25:24
A:
Management Studio 2008 for SQL 2000/2005/2008, and the Intellisense has made SQL Prompt obsolete
Si Downes
2010-07-13 14:24:48
I don't think intellisense completely makes sql prompty obsolete. I use sql prompt snippets all the time and I think they are great.
TheImirOfGroofunkistan
2010-07-17 14:35:24