Best SQL IDE???

23 Sep 2005 9:26 PM

Robert Davis

Anyone have any thoughts on the best IDE for SQL Server development? I'd
like object explorer, drag-and-drop, code formatting, code completion, code
analysis, execution, query builder, the WORKS! I've tried RapidSQL, having
gotten excited by their online demo, but I have not found it well-behaved.
It completely crashed no less than 5 times in as many minutes. D'oh!

TIA!

Robert

23 Sep 2005 9:35 PM

JT

I havn't had time to try this out myself, but there is a 3rd party tool for
enabled T-SQL intellisense style code completion. It claims to work with
Query Analyzer, VS 2003 and 2005 Enterprise Manager.
http://www.promptsql.com/
I don't know about formatting. I have my own style of structured indenting
and comes so natural I don't even think about it when typing.

Show quote

"Robert Davis" <radb***@yahoo.com> wrote in message
news:eP5T2VIwFHA.724@TK2MSFTNGP14.phx.gbl...
> Anyone have any thoughts on the best IDE for SQL Server development? I'd
> like object explorer, drag-and-drop, code formatting, code completion,
> code analysis, execution, query builder, the WORKS! I've tried RapidSQL,
> having gotten excited by their online demo, but I have not found it
> well-behaved. It completely crashed no less than 5 times in as many
> minutes. D'oh!
>
> TIA!
>
> Robert
>

23 Sep 2005 9:35 PM

Aaron Bertrand [SQL Server MVP]

Personally, I like Management Studio (SQL Server 2005) with PromptSQL (which
gives you IntelliSense in SSMS, Query Analyzer, etc). I'm pretty religious
about code formatting, and I have no need for a "query builder" (especially
those with bugs or really nasty side effects).

"Best" is going to be pretty subjective, since everyone has their own
opinions, criteria, etc. Like what is the best car, I can't even count how
many variables go into that, and why you get as many answers as there are
people.

A

Show quote

"Robert Davis" <radb***@yahoo.com> wrote in message
news:eP5T2VIwFHA.724@TK2MSFTNGP14.phx.gbl...
> Anyone have any thoughts on the best IDE for SQL Server development? I'd
> like object explorer, drag-and-drop, code formatting, code completion,
> code analysis, execution, query builder, the WORKS! I've tried RapidSQL,
> having gotten excited by their online demo, but I have not found it
> well-behaved. It completely crashed no less than 5 times in as many
> minutes. D'oh!
>
> TIA!
>
> Robert
>

23 Sep 2005 10:00 PM

John Bell

Hi

You may want to look through the Readers choices in the September SQL Server
Magazine
http://www.windowsitpro.com/SQLServer/Issues/IssueID/786/Index.html

John

Show quote

"Robert Davis" <radb***@yahoo.com> wrote in message
news:eP5T2VIwFHA.724@TK2MSFTNGP14.phx.gbl...
> Anyone have any thoughts on the best IDE for SQL Server development? I'd
> like object explorer, drag-and-drop, code formatting, code completion,
> code analysis, execution, query builder, the WORKS! I've tried RapidSQL,
> having gotten excited by their online demo, but I have not found it
> well-behaved. It completely crashed no less than 5 times in as many
> minutes. D'oh!
>
> TIA!
>
> Robert
>

23 Sep 2005 10:55 PM

Trey Walpole

I've had good success with ApexSQLEdit - has intellsense, execution
plans [not as graphic as SQL Q/A - i.e., in a flowchart view, but not
with icons for seeks, scans, etc., but has the text to explain it], and
integration with source control.
www.apexsql.com

They have other good tools as well.

Robert Davis wrote:

Show quote

>Anyone have any thoughts on the best IDE for SQL Server development? I'd
>like object explorer, drag-and-drop, code formatting, code completion, code
>analysis, execution, query builder, the WORKS! I've tried RapidSQL, having
>gotten excited by their online demo, but I have not found it well-behaved.
>It completely crashed no less than 5 times in as many minutes. D'oh!
>
>TIA!
>
>Robert
>
>
>
>

27 Sep 2005 5:37 PM

expertware

Here is another query builder to keep an eye on:

http://151.100.3.84/technicalpreview/

Pamela