Microsoft Visual Studio Team System 2008 Database Edition Power Tools is a set of enhancements and tools that complement and improve the user experience of VSTS Database Edition 2008
Power Tools 2008.doc
This release updates the Power Tools for the Database Edition to work with Visual Studio 2008 and provides several new features. The new features include two custom unit test conditions, a new Data Generation Wizard, and new MSBuild tasks to support running TSQL Static Code Analysis from the command line.
The updated features include 5 refactoring types, a dependency viewer, additional data generators and editors, 2 MSBuild tasks for Schema and Data Compare and the TSQL Static Code Analysis feature
New Test Conditions for Database Unit Tests
• ChecksumCondition – You can use this test condition to verify that the checksum of the data set returned by a database unit test matches the checksum of an expected data set.
• ExpectedSchemaTestCondition – You can use this test condition to verify that the column names and data types of the returned data set match expected values.
Data Generator Improvements
• New Data Generator Wizard – This new wizard creates a data generation plan that is configured to copy data from a source database. You can use this wizard when you need to copy most of your data from a live source, but need to make small changes to ensure privacy.
MSBuild Task Improvements
• SqlAnalysis Task – You can use this build task to run T-SQL Static Code Analysis from MSBuild.
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.
• “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
• Data / Schema Compare Build Tasks - MSBuild tasks that can generate scripts as if the user had run the Data / Schema compare UI
• 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
• Script Preprocessor - Expand SQLCMD variables and include files and command line version (sqlspp.exe) & an MSBuild version ( wraps the command line version )
Supported Operating System
Windows 2000 Service Pack 4, Windows Server 2003 Service Pack 1, Windows Vista
Requirements vary for different combinations of features within the Database Edition. To install this product, we recommend:
• Computer with a 2.0 GHz processor
• 512 MB of RAM (1 gigabyte [GB] recommended)
• 3 GB of available hard-disk space
• DVD-ROM drive
• 1024x768 resolution with 256 colors
• Keyboard and mouse or compatible pointing device
• Visual Studio Team System 2008 Database Edition OR Visual Studio Team System 2008 Team Suite
• An instance of SQL Server 2005 (Developer, Enterprise, Standard, Express, or Evaluation Edition)
Note: You must install Visual Studio Team System 2008 Database Edition or Visual Studio Team System 2008 Team Suite before you install the power tools for the Database Edition.
You can find documentation for Database Edition as part of the online MSDN Library. In addition, you can install the documentation on your local computer from the most recent release of the MSDN Library.