Visual Studio Team System 2008 Database Edition Power Tools


The “DataDude” team is happy to announce the availability of the Power Tools for Visual Studio Team System 2008 Database Edition.

The Power Tools for 2008 contains all the functionality we shipped in 2005 plus:

  • Command line SQL Static Code Analysis execution through MSBuild, this was the biggest customer request, which is why I was holding the release. This enables SQL Static Code Analysis to be an integrated part of Team Build!
  • Data Generation Wizard; this is another customer request where we allow users to create a new data generation plan by pointing at an existing database, the plan will be fully configured by the wizard to pull all data from the database using the Sequential Databound Generator. This way users can use an existing data set and only override columns which impose risks because of for example privacy concerns and save about half a day or more of configuring a data generation plan from scratch, one column at the time.
  • File based data generator; this allows you to insert the content of files in to the database (works for string and binary, not for XML yet).
  • XML based data generator; this allows you to generate XML based on an XSD (the XSD has to be provided as file right now, and cannot be selected from database or inherited from the data type).
  • Unique Regular Expression generator; this adds the ability to generator unique values using the RegEx String generator.
  • Refactoring Command Generator has been made available as a MSBuild task for better project build integration so it can be made part of the pre-build and pre-deployment stages in the project. This allows users to automated the results of refactoring to some degree in to the project.
  • We added two new test conditions for Database Unit Tests
    • ChecksumCondition – Which you can use to verify that the checksum of the data set returned by a database unit test matches the checksum of an expected data set.
    • ExpectedSchemaTestCondition – Which you use to verify that the column names and data types of the returned data set match expected values.

Download page:
http://www.microsoft.com/downloads/details.aspx?FamilyID=73ba5038-8e37-4c8e-812b-db14ede2c354&displaylang=en

Installer download:
http://download.microsoft.com/download/f/b/8/fb8d1c0d-c0c4-4004-ab86-12396b2a3ee3/VSTSDB2008PT.msi

Documentation download:
http://download.microsoft.com/download/f/b/8/fb8d1c0d-c0c4-4004-ab86-12396b2a3ee3/Power Tools 2008.doc

Happy Valentine’s day!

-GertD

Comments (13)

  1. Huge congratulations to Gert and the rest of the “DataDude” team  for releasing the

  2. Huge congratulations to Gert and the rest of the “DataDude” team  for releasing the

  3. Andy Leonard says:

    Gert and team announce the availability of Power Tools for Visual Studio Team System 2008 Database Edition

  4. Gert and team announce the availability of Power Tools for Visual Studio Team System 2008 Database Edition

  5. Команда DataDude ударными темпами выпускает всё новые и новые веси и редакции замечательной инструментальной

  6. adamja says:

    You have made my day, as I just purchased 2008 DB Edition today.  You guys are making this a very sweet tool for database developers.

  7. Got VSTS 2008 Database Edition ? Then, you’ll love this: Earlier today, a colleague of mine notified

  8. Got VSTS 2008 Database Edition ? Then, you'll love this: Earlier today, a colleague of mine notified

  9. Соррі, ще один раз проспамлю. Я мабуть стану дзеркалом блогу Data Dude … Реліз Power Tools для DbPro.

  10. Bien, desde el 15 de Febrero, ya tenemos disponible  el paquete de Power Tools for Visual Studio

  11. The long-awaited power tools for VSTS 2008 DB edition have been released , which restore the sorely-missed

  12. rpraetorius says:

    Is there an items collection that would let me control which tables get compared by SqlDataCompareTask?  I tried

     <ItemGroup>

       <Tables Include="Table1"/>

     </ItemGroup>

    as a stab in the dark (sometimes things are this obvious.  Usually not).  Is there some other way to control which tables get compared when running SqlDataCompareTask using msbuild on the command line?

  13. [ Nacsa Sándor , 2009. február 8.] Ez a Team System változat az adatbázis változások kezeléséhez és teszteléséhez