Tag Archives: #ssdt

Versioning your database packages (.dacpac) with the new Build Agent

October 30, 2016 by Wes MacDonald 0 Comments


If you’re interested in versioning your database packages with the new build agent here is an easy way to get started.  I started off with the following PowerShell example of a build script from the Visual Studio product groups’ build docs for versioning C# and VB projects and made a few tweaks to update the relevant XML […]

Continue reading →
SQL Server, Team Foundation Server, Visual Studio Team Services
, , , , , ,

Project contains an invalid database reference

October 30, 2016 by Wes MacDonald 0 Comments


If you have multiple developers working in a SQL Server Database Project and not all developers have applied the latest update they may see the following compilation error message for the System Database references: master and msdb. Project ‘[project_name].sqlproj’ contains an invalid database reference: ‘C:\Program Files (x86)\Microsoft Visual Studio 14.0\Common7\IDE\Extensions\Microsoft\SQLDB\Extensions\SqlServer\120\SqlSchemas\master.dacpac’.  You must update the reference so that […]

Continue reading →
SQL Server, Visual Studio
, , ,
Successful Deployment of .dacpac using the RM Deployment Agent

Release Management for Visual Studio 2013 and SQL Server 2014 Database Deployments

June 10, 2014 by Wes MacDonald 9 Comments


Visual Studio 2013 comes with built-in support to manage database projects, the SQL Server Data Tools (SSDT) were updated in March 2014 to include support for SQL Server 2014.  If you have Visual Studio 2012 use the SQL | Check for Updates inside Visual Studio or download. If you have Visual Studio 2013 use Tools […]

Continue reading →
Release Management, Visual Studio 2013
, , ,