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 Thanks, Chris B.
May check on the Tools section above on this website. Satya SKJ Moderator http://www.SQL-Server-Performance.Com/forum This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
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 />