SQL Server Data Tools

Official team blog for SSDT, a tool for on- and off-premises database development

Check out Juneau in a Hands-on-Lab today…

The TechEd North America 2011 site provides many HOLs for online access. If you want to play with Juneau but are still waiting for us to go public, now is the time to get started. Notice that you may have to create a new myTechEd ID to download the lab manual.

Join the SQL Server Developer Tools Advisory Program!

Are you a TSQL developer interested in developing database projects for SQL Server Code-Named “Denali” and SQL Azure? Do you want access to the SQL Server Developer Tools, Code-Named “Juneau” (SSDT) engineering team and influence the design of our product going forward?

Watch these videos of Juneau in action!

SQL Server Developer Tools, codename ‘Juneau” has been presented to various audiences in multiple events recently. Here’s a list of all the videos for your viewing pleasure!
NEW: TechEd North America 2011
Mark Wilson-Thomas was interviewed during TechEd and talked about the value proposition of Juneau.

Welcome!

Welcome to the SQL Server Developer Tools, Codename “Juneau” team blog!
In this initial blog post, we want to give you a general idea of what our product offers. Stay tuned as we roll out more posts in the near future.

Uncategorized

Announcing the General Availability (GA) Release of SSDT 17.0 (April 2017)

We are pleased to announce that SQL Server Data Tools 17.0 is officially released and supported for production use. This GA release includes support for SQL Server 2017 and SQL Server on Linux including new features such as Graph DB. It includes several features that we have consistently received requests for via MSDN forums and Connect and contains numerous fixes and improvements over the 16.x version of the tools.

SQL Server Data Tools 17.0 RC, and SSDT in VS2017

It’s been a busy few months for SSDT with multiple Release Candidate releases of the 17.0 major release, and Visual Studio 2017 shipping this week. Here’s a quick update on the latest & greatest database tools updates you can try out.

SQL Server Data Tools 16.5 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.5 release adds a number of improvements to the connection experience, SqlPackage and DacFx API support for generating a deployment report and scripts during publish,

SQL Server Data Tools 16.4 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.4 release adds support for Schema Compare in SqlPackage.exe and as an API, Integrated Workspace Mode for SSDT Tabular,

Schema Compare in SqlPackage and the Data-Tier Application Framework (DACFx)

In the most recent version of SqlPackage.exe and the Data-Tier Application Framework (DACFx), we have introduced some new functionality: Schema Compare! A couple of years ago we added MSBuild support for Schema Compare.  We’ve now extended that support to SqlPackage.exe and DACFx.

SqlPackage.exe: How to get detailed information about supported parameters

Recently we have received questions about sqlpackage.exe and its supported parameters. In this blog I will share a simple tip to get the help information about all supported parameters and properties for a specific action from the version of sqlpackage.exe that you use.

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 –

Part 5. Use your own Build and Deployment Agent

This blog is part 5 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
Part 3.

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.

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.