Tag Archives: sql server data tools

Case sensitive dacpac for coding standards

Posted on December 7, 2016 by erictummers

In our project we have coding standards for SQL objects. But when a code review made us update casing we noticed the dacpac did not contain the changes after a schema compare. What happend? Seems that our sql server databases … Continue reading →

Posted in Development | Tagged , , , , | 2 Comments

Version store out of memory

Posted on June 29, 2016 by erictummers

In our current project we use Sql Server Data Tools (sqlproj) to put our database in source control. Recently we experienced random exceptions during loading and building the solution with multiple sql projects. Last week our builds started to fail. … Continue reading →

Posted in Development | Tagged , , , | 1 Comment

Azure SQL Server for centralized database

Posted on October 21, 2015 by erictummers

We are doing a project for our Business Intelligence team. For this we need a central database that is always available. This is where Azure comes to mind. I’ll describe here how I managed to configure Azure SQL Server to … Continue reading →

Posted in Uncategorized | Tagged , , , | 2 Comments

Allow incompatible platform in schema comparison

Posted on June 4, 2014 by erictummers

Schema comparison of SQL Express 2012 database and SQL Server 2008 gives an error A project which specifies SQL Server 2012 as the target platform cannot be published to SQL Server 2008. Set the allow incompatible platform in the options … Continue reading →

Posted in Tooling | Tagged , | 2 Comments

SQL Server Data Tools in Visual Studio 2013

Posted on March 12, 2014 by erictummers

Visual Studio 2013 has Sql Server Data Tools built in. (Pro, Premium and Ultimate) We use it to compare and sync databases. The first time I started the data compare it did not work. When comparing the data between databases … Continue reading →

Posted in Tooling | Tagged , , , , , | 4 Comments