Heute wird der erste RC der kommenden Power Tools für Visual Studio Team Edition for Database Professionals veröffentlicht. Folgende Neuerungen sind in den Tools enthalten:

Dependency Viewer

Refactoring

• Move Schema
• Expand Wildcard
• Fully Quality Name
• Refactor in to strongly typed DataSet definitions
• Refactor Command Generator

Data Generation

• Sequential Data Bound Generator
• Editors for the Data Bound Generator, Sequential Data Bound Generator and RegEx String Generator to make configuration easier
• The RegEx editor also tries to interpret your CHECK CONSTRAINTs and create a matching RegEx expression that you can use to generate data values that match the constraint definition
• The RegEx editor can also be used for interactively defining and testing RegEx expressions and evaluate the output visually, which makes it a lot easier to create the right RegEx expression for your value domain.

MSBuild Tasks

• SqlSchemaCompareTask; allows you to compare schemas between two database from the command line using MSBuild.
• SqlDataCompareTask; allows you to compare the content of tables within two databases from the command line using MSBuild.

T-SQL Static Code Analysis

 Miscellaneous tools

• SQL script pre-processor command-line utility, which will expand all SQLCMD includes and variable definitions (sqlspp.exe)

Schema Manager API

Ausführliche Informationen befinden sich im Data Dude Blog.