Tag Archives: #ssdt

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

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

Project contains an invalid database reference

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
Successful Deployment of .dacpac using the RM Deployment Agent

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

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