Power Tools Download Link

  • Article

They are here!

  • 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

See https://blogs.msdn.com/gertd/archive/2007/08/07/it-is-august-6th.aspx for a more detailed explanation.

The Visual Studio Team Edition for Database Professionals first Power Tools release can be downloaded from the following location:

Power Tools download: https://go.microsoft.com/fwlink/?LinkId=88852

The Power Tools require that you have Service Release 1 installed, which you can download from the following location:

Service Release 1 download: https://go.microsoft.com/fwlink/?LinkId=88853

I will be offline for 3 weeks and I will pick up the blogging pace with lots of new posts when I am back after Labor day.

Later,
-GertD