Freigeben über


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:
https://www.microsoft.com/downloads/details.aspx?FamilyID=73ba5038-8e37-4c8e-812b-db14ede2c354&displaylang=en

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

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

Happy Valentine’s day!

-GertD

Comments

  • Anonymous
    February 14, 2008
    Huge congratulations to Gert and the rest of the “DataDude” team  for releasing the

  • Anonymous
    February 14, 2008
    Huge congratulations to Gert and the rest of the “DataDude” team  for releasing the

  • Anonymous
    February 14, 2008
    Gert and team announce the availability of Power Tools for Visual Studio Team System 2008 Database Edition

  • Anonymous
    February 14, 2008
    Gert and team announce the availability of Power Tools for Visual Studio Team System 2008 Database Edition

  • Anonymous
    February 14, 2008
    Команда DataDude ударными темпами выпускает всё новые и новые веси и редакции замечательной инструментальной

  • Anonymous
    February 15, 2008
    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.

  • Anonymous
    February 15, 2008
    Got VSTS 2008 Database Edition ? Then, you'll love this: Earlier today, a colleague of mine notified

  • Anonymous
    February 15, 2008
    Got VSTS 2008 Database Edition ? Then, you'll love this: Earlier today, a colleague of mine notified

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

  • Anonymous
    February 16, 2008
    The comment has been removed

  • Anonymous
    February 16, 2008
    The long-awaited power tools for VSTS 2008 DB edition have been released , which restore the sorely-missed

  • Anonymous
    March 07, 2008
    The comment has been removed

  • Anonymous
    February 08, 2009
    [ 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