One of the coolest feature of Database Projects in VS2008 is the ability to synchronize the database project with a physical instance of SQL server.
This is useful if not all people from the team have the ability to run a database project (this is solved in vs2010 where database project are available even in the [...]

Continue reading about Pay attention to file length in database project after a synchronization

alkampfer on January 4th, 2010

If you want to deploy a database project into a target sql server instance during a tfs 2010 build, you can use with success the basic MsBuildTask, similar to tfs2008.
I decided to deploy the database, only if the tests are ok and the build is ok, so I place a condition activity under the test [...]

Continue reading about Deploy a database project with tfs build 2010

alkampfer on December 30th, 2009

Custom Rule for database projects is one of my favorite extension point of Visual Studio 2008, and I blogged about it some time ago. Yesterday I tried to convert my sample rule for visual studio 2010 beta2, and there are a lot of things that are changed. The result will be a simple rule that [...]

Continue reading about Create a SqlRule for database project in vs2010 beta2