Visual Studio 2008 Team System Database Project Templates for SQL Server 2008

Posted by on 4 May, 2009 Leave a comment (2) Go to comments

The Database templates in Visual Studio 2008 Team System are used to e.g. create automagic test data generation plans which then can be utilized in WebTests using a DataSource binding for a field value and then use the WebTests to create a LoadTest. It’s absolutely awesome and impressive how this is done in Visual Studio (only available in Team System edition).

The only little problem is that Visual Studio 2008 only ships Database templates for SQL Server 2000 and 2005. The Database templates for SQL Server 2008 are at: Microsoft® Visual Studio Team System 2008 Database Edition GDR R2 and require Visual Studio 2008 SP1.

A screencast on how to generate test data for a database at: How Do I: Generate Test Data using Visual Studio Team System Database Edition?

    Related Posts:

    1. Windows Vista is a pile of shit
    2. DataGridView revamp for Mono 2.4 – Data Binding and more
    Coding, ,
    • Mark Latham

      Great – got that one. Do you also know where I might find VS 2008 Database Project templates for other datasources like Oracle, etc and Excel/flat files?

    • Mark Latham

      The answer to my own question – they are located under Other Project Types>Database.

      So another question if anybody is still listening:
      I want to create an VS 2008 Database Project for excel that initially captures the meta-data from an existing workbook which can then be updated. In other words I would like to manage excel (and text file) meta-data in the same way as a regular database project.

      I have tried adding a database project (above) with an Excel ODBC driver and C#>Office>Excel 2007 project but neither returns any meta-data. I also tried the Microsoft JET 4.0 OLEDB Provider but could not get it to work.

      Any thoughts greatly appreciated.