• Daniel Bowlin (2/17/2011)


    Can someone suggest a good reference to learn more about Visual Studio database projects?

    Thanks.

    I blog about it quite a bit here: http://sqlblog.com/blogs/jamie_thomson/archive/tags/Datadude/default.aspx

    Its a little bit of a self-promotion but then, I did write the QoD so why not ... 🙂

    Otherwise, here is my master list of datadude-related links that I carry everywhere with me:

    Datadude stuff

    Build and Deploy Databases to an Isolated Development Environment

    (http://msdn.microsoft.com/en-us/library/dd193409.aspx)

    An Overview of Database Build and Deployment

    (http://msdn.microsoft.com/en-us/library/aa833165.aspx)

    Apply Test-Driven Development to your Database Projects

    (http://msdn.microsoft.com/en-us/magazine/dvdarchive/cc164243.aspx)

    Walkthrough: Partition a Database Project by Using Composite Projects

    (http://msdn.microsoft.com/en-us/library/dd193415.aspx)

    Right sizing the master.dbschema file for better design time performance

    (http://blogs.msdn.com/b/bahill/archive/2009/03/23/right-sizing-the-master-dbschema-file-for-better-design-time-performance.aspx)

    Referencing for Shared Server-Level Objects

    (http://msdn.microsoft.com/en-us/magazine/dd483214.aspx#id0100036)

    Verifying Database Code by Using Unit Tests (MSDN)

    (http://msdn.microsoft.com/en-us/library/dd172118.aspx)

    Visual Studio 2010 SQL Server Database Projects

    (http://msdn.microsoft.com/en-us/library/ff678491.aspx)

    A comparison of DAC and regular .dbproj projects

    How to: Prepare a Database for Deployment From a Command Prompt by Using VSDBCMD.EXE

    (http://msdn.microsoft.com/en-us/library/dd193258.aspx)

    ------------------------------------------------------------------------------------------------

    MSTest stuff

    MSTest.exe Command-Line Options

    (http://msdn.microsoft.com/en-us/library/ms182489%28v=VS.80%29.aspx)

    How to: Run Database Unit Tests from Team Foundation Build

    (http://msdn.microsoft.com/en-us/library/aa833210.aspx)

    ------------------------------------------------------------------------------------------------