Unable to publish DB project on Azure SQL Data Warehouse

Question

With Visual Studio 2019 (already updated to the latest version), I have created a new SQL Server Database Project connected to an Azure SQL Datawarehouse Database.

I imported all the object already present on the database (tables, stored procedure and schema), I carried out the schema compare which does not detect any difference.

On the project properties I changed the Target platform setting it up on Miscrosoft Azure SQL Data Warehouse, I switched the Compatibility level setting it on SQL Server 2017 (140)

The build of solution is successful, but when I tried to publish the solution I have the following message error

Creating publish preview...
    Errors occurred while modeling the target database. Deployment can not continue.

I can generate the publish script only if I check the box Always re-create database, but I don't want drop and re-create the database every time

I did a lot of research but none of them solved my problem.

Anyone knows if there are any known limitations concerning the publish of SQL Server Database Project on Azure SQL Datawarehouse Database or does anyone know how to solve the problem?

Thank you

Answer 1

Deploying database projects to Azure SQL Data Warehouse is in public preview since August if you use Visual Studio 2019 SQL Server Data Tools (SSDT) as documented here. At the bottom of the page Microsoft gives you instructions on how you can provide feedback directly to the SSDT team.

Database projects were not supported on Azure SQL Data Warehouse as you can read here and here.

Answer 2

Check your database tables in the "System Tables." If you have dbo.sysdiagrams, that won't allow you to deploy the db.

So, if you delete dbo.sysdiagrams table on your database, that will hopefully allow you to deploy the database.

They get created when you click on the database diagrams.