Hi,
Does anyone have a list of or recommendation for tools to use in T-SQL/SQL7/2000 development? Currently, our arsenal consists of Enterprise Manager and Query Analyzer. I am looking at BMC SQL Programmer and a product called OpenSoft SQL Studio. Any comments on these or other products. My main interests are:
- better T-SQL/SQL IDE/Editor than Query Analyzer
- T-SQL debugger
- Script generation/management (i.e. for updates sent to sites)
I am also looking for a good and preferably not overly inexpensive CASE/data modeling tool. I understand I may want a separate tool for this.
TIA,
Ken B. Matson
GCom2 Solutions