With SQL Server Data Tools generally available and native Azure DevOps support, you can now set up stable release pipelines without any custom code, and changes to your data warehouse model can be safely and automatically promoted across development, testing, and production environments. Preview customers such as T-Mobile will now be able to accelerate their feature development with Azure Synapse. Since announcing preview support for SQL Server Data Tools (SSDT), customers have been able to use popular SQL Server Data Tools features such as Schema Compare, build, and publish for local development of their data warehouse. Although this has helped customers accelerate project development, an automated build, test, and deployment infrastructure is still critical for continuous integration and deployment (CI/CD) scenarios. Without the native integration with Azure DevOps, customers were still forced to manually write PowerShell and TSQL scripts integrated with Azure DevOps for an automated release process. You can now expect a frictionless development and deployment experience on any platform for your analytics solution. This announcement also comes with support for the Schema Compare extension in Azure Data Studio for SQL Analytics.

This release includes support for SQL Server Data Tools with Visual Studio 2019 along with native platform integration with Azure DevOps providing built-in continuous integration and deployment (CI/CD) capabilities for enterprise level deployments. Today we are announcing the general availability of the highest requested feature for SQL Analytics in Azure Synapse, SQL Server Data Tools (SSDT) database projects. At Microsoft Ignite 2019, we announced Azure Synapse Analytics, a major evolution of Azure SQL Data Warehouse. The same industry leading data warehouse now provides a whole new level of performance, scale, and analytics capabilities. One of these capabilities is SQL Analytics, which provides a rich set of enterprise data warehousing features.

Azure data studio schema compare