SQL Server Performance

Good entry-level SQL development? Any Recommendati

Discussion in 'Third Party Tools' started by cbarone, Jun 30, 2005.

  1. cbarone New Member

    Hi All.

    Does anyone have a suggestion for a good entry-level SQL development
    tool? The environment I'm outfitting is:

    5 - 10 novice SQL report developers
    SQL will be hitting MS SQL 2000 and MS Access
    SQL will be used by Actuate Reports
    Must have a graphical (drag-n-drop) query builder
    Must assist with code formatting and syntax
    Ideally will have run-away query control
    Should have decent help facility
    Should be compatible with any SQL-92 ODBC source


    Chris B.
  2. satya Moderator

  3. FrankKalis Moderator

    Maybe you find something useful in here: <br /<a target="_blank" href=http://www.databaseanswers.com/modelling_tools.htm>http://www.databaseanswers.com/modelling_tools.htm</a><br /<a target="_blank" href=http://www.visual-paradigm.com/product/dbva/>http://www.visual-paradigm.com/product/dbva/</a><br /><br />Personally I think, you'll have a very hard time finding anything that suits all your requirements equally well. You might also find that with a "simple" editor-like tool like Query Analyzer, Toad or<a target="_blank" href=http://www.yohz.com/product_qat.html>http://www.yohz.com/product_qat.html</a> you have more control about what is going on. Just one example: Try to create a CASE expression in a query with the graphical query builder in Enterprise Manager. <br /><br />Anyway, I would be interested in your feedback when you have found something. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Ich unterstütze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>) <br />

Share This Page