Azure SQL Data Warehouse Db Development Tools

Question

With the new release of SSDT I noticed the addition of Azure objects such as External Tables and such. However in the Target Db platform Configuration of the Database project I do not see Azure SQL Data Warehouse as an option, just Azure SQL Server. Does anyone know of a tool to effectively do database development against Azure SQL Data Warehouse (such as SQL Schema Compare and change script generation)?

Answer 1

Please vote and add your comments to the feedback request too.

We have recently added SQL DW support to SSMS. While it might do all that you are looking for, the Generate Scripts feature might help.

Answer 2

To elaborate on a manual workaround, you can use the SQL Server 2016 project template as a logical container for your DDL in source control (VSTS) ignoring all DW specific syntax when building the project. This is available in Visual Studio today for free. Change management is a manual process where you have to drop and recreate your objects with permissions be re-instantiated in the target environment. This can be somewhat automated via TSQL and Powershell. For tables, you’d check if columns exist and adding them accordingly. This can also be automated via PowerShell and TSQL scripts. If you use VSTS, you can leverage build server functionality (triggers) for continuous integration or delivery/deployment.

If you would like to automate scripting, also check out the mssql-scripter tool for SQL DW:

https://azure.microsoft.com/en-us/updates/azure-sql-data-warehouse-support-for-mssql-scripter/