AboutThis blog is mostly about my work, but expect an occasional home project, productivity tip and tooling review.
Most used tags
Tag Archives: sql server data tools
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
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
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
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