Releasing SSDT with Visual Studio “15” Preview 4 and introducing SSDT MSBuild NuGet package

Today marks the release of Visual Studio “15” Preview 4. The SQL Server Data Tools team is happy to announce support for the relational database set of SQL tools – SQL Projects, Schema Compare, Data Compare, and SQL Server Object Explorer – in this Visual Studio release. This release includes a great number of new… Read more

Part 5. Use your own Build and Deployment Agent

This blog is part 5 of Use your own Build and Deployment Agent with Continuous Integration and Continuous Deployment. Content of Tutorial: Part 1. Prerequisite for Azure SQL Database Build and Deployment Automation Part 2. Automate Building Azure SQL Database with Continuous Integration Part 3. Create NuGet package for Azure SQL Database Part 4. Orchestrate Azure SQL Database… Read more

SQL Server Data Tools 16.3 Release

The SQL Server Data Tools team is pleased to announce an update for SQL Server Data Tools (SSDT) is now available. The SSDT 16.3 release introduces new Tabular Model Explorer, enhancements for Always Encrypted experience with new key management dialogs and various bug fixes. Get it here: Download SSDT GA 16.3 for Visual Studio 2015 and Visual Studio… Read more

SQL Server Data Tools July Update

The SQL Server Data Tools team is pleased to announce an update for SQL Server Data Tools (SSDT) is now available. The SSDT update for July 2016 adds bug fixing and enhanced support for SQL Server 2016 features such as Always Encrypted and Temporal Table. This update also introduces a ‘safe installation‘ experience. It aims to guarantee the installation… Read more

SQL Server Data Tools GA update for June 2016

The SQL Server Data Tools team is pleased to announce an update for SSDT General Availability (GA) is now released. The SSDT GA update for June 2016 added support for the latest updates of SQL Server 2016 RTM, various bug fixes.   Get it here: Download SSDT GA June 2016 for Visual Studio 2015 and Visual Studio 2013 The… Read more

SQL Server Data Tools Preview update for April 2016

The SQL Server Data Tools team is pleased to announce an update for SSDT Preview is now available. The SSDT Preview update for April 2016 added support for the latest updates of SQL Server 2016 RC3, various bug fixes.   Get it here: Download SSDT April 2016 Preview for Visual Studio 2015 and Visual Studio 2013 The version number… Read more

Automate Build and Deployment of Azure SQL Database with Continuous Integration and Continuous Deployment

One of key benefits of developing database with SSDT is you can easily integrate Application Lifecycle Management (ALM) practices to database development. You can develop and manage your database in source control such as Git, automate build with continuous integration and orchestrate releases with continuous deployment. In this blog, we will walk through a series… Read more

Part 1. Prerequisite for Azure SQL Database Build and Deployment Automation

This blog is part 1 of Automate Build and Deployment of Azure SQL Database with Continuous Integration and Continuous Deployment. Content of Tutorial: Part 1. Prerequisite for Azure SQL Database Build and Deployment Automation (this page) Part 2. Automate Building Azure SQL Database with Continuous Integration Part 3. Create Nuget package for Azure SQL Database Part… Read more

Part 2. Automate Building Azure SQL Database with Continuous Integration

This blog is part 2 of Automate Build and Deployment of Azure SQL Database with Continuous Integration and Continuous Deployment. Content of Tutorial: Part 1. Prerequisite for Azure SQL Database Build and Deployment Automation Part 2. Automate Building Azure SQL Database with Continuous Integration (this page) Part 3. Create Nuget package for Azure SQL Database Part… Read more