Tag Archives: sql server data tools

Case sensitive dacpac for coding standards

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 , , , , | Leave a comment

Version store out of memory

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 , , , | Leave a comment

Azure SQL Server for centralized database

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 , , , | 1 Comment

Allow incompatible platform in schema comparison

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

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