VSTS for DB Pro Power Tools

Dopo il rilascio della Service Release 1  ecco un nuovo pacchetto per Team System for Database Professionals. Include una serie interessante di strumenti di refactoring per Stored Procedure e Schema e una anticipazione di quello che avremo con VS 2008 per quanto riguarda l’analisi del codice TSQL


Molto interessante il Dependency Tree Viewer per visualizzare le dipendenze fra oggetti DB.


Ecco le specifiche


TSQL Static Code Analysis
• Static Code Analysis – A precursor to the functionality that will be in future versions of VSTS that will allow you to perform Static Code Analysis on T-SQL code.

Refactoring
• “Move Schema” Refactoring – Allows a user to right click on an object and move it to a different but existing schema
• SP Rename Generation – Generate a new script that will contain sp_renames for all rename refactored objects that the user can then execute.
• Wildcard Expansion – Automatically expand the wildcard in a select to the appropriate columns.
• Fully-Qualified Name Support – Automatically inject fully-qualified names when absent in a script
• Refactoring extended to Dataset – Refactor into strongly typed dataset definitions

MSBuild Tasks
• Data / Schema Compare Build Tasks – MSBuild tasks that can generate scripts as if the user had run the Data / Schema compare UI

Schema View
• API Access to Schema View – Insert / Update / Delete to schema View and list schema objects and their associated files

Dependency Tool Window
• Dependency Tree – Show the dependencies ( incoming / outgoing ) for selected schema objects in a new tool window

Miscellaneous Tools
• Script Preprocessor – Expand SQLCMD variables and include files and command line version (sqlspp.exe) & an MSBuild version ( wraps the command line version )


Il download http://www.microsoft.com/downloads/details.aspx?FamilyID=DA3F11AD-BD54-4EDA-B08C-4DF84DF0D641&displaylang=en.