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
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)
------------------------------------------------------------------------------------------------
Jamie Thomson
http://sqlblog.com/blogs/jamie_thomson