DacFx Public Model Tutorial

Recently there has been an increasing interest in extending the capabilities of SSDT and DacFx. The walkthrough guides for creating new build and deployment contributors and database unit test conditions are a useful start in exploring the tools, but they only scratch the surface of what’s possible. They also don’t really show the best practices… Read more

SQL Server Data Tools for SQL Server 2014 CTP2 is available

We’d like to announce the availability of SSDT that supports SQL Server 2014 databases.  SQL Server Data Tools for SQL Server 2014 CTP2 is pre-release software, does not support upgrade from an existing SSDT install or upgrading to any new versions of SSDT to be released, and should be installed only on a clean machine. … Read more

Updated SQL Server Data Tools October 2013

The October 2013 release contains an updated installer that does not fail due to certificate validation of the chained MSIs.  This release also contains a code change that will allow graceful handling of SQL Server 2014 CTP2 connections where not supported.  Get it here: http://msdn.microsoft.com/en-us/data/hh297027   Contact Us If you have any questions or feedback,… Read more

Known issue: SSDT install fails validating certificates

We are aware of a new issue today where installing SSDT will fail with the following message “A required certificate is not within its validity period when verifying against the current system clock or the timestamp in the signed file.”  This is due to an issue in the installer verification code with a SHA256 certificate that… Read more

Updated Sql Server Data Tools for September 2013

The September 2013 release has a targeted fix for the Schema Compare error when working with large display text or high DPI.  This release will replace the August 2013 release and contains the same bug fixes with this one additional fix.  We appreciate your patience while we worked to publish this update. Get it here… Read more

Updated SQL Server Data Tools and Data-Tier Application Framework for August 2013

The SSDT team is pleased to announce that SQL Server Data Tools – August 2013 update is now available for download. Get it here: SSDT for Visual Studio 2012: http://msdn.microsoft.com/en-us/jj650015 SSDT for Visual Studio 2010: http://msdn.microsoft.com/en-us/jj650014 What’s New? Updated Data-Tier Application Framework SSDT – August 2013 includes a new redist of SQL Server Data-Tier Application… Read more

Optimizing Scripts for Faster Incremental Deployment

Incremental deployment is the process of updating an existing database with new changes that were made by the developer in SSDT. Below we show you a tip on how to speed up incremental deployment by storing your scripts in their canonical form. Background SQL Server stores scripts in canonical form to have a standardized way… Read more

SQL Server Data-Tier Application Framework (July 2013) Available

What’s new? This update to the Data-Tier Application Framework (DACFx) addresses a high-priority customer reported issue causing potential corruption of DAC package artifacts, including pre- and post-deployment scripts, during database project build. The issue is described below: Scenario/Issue Building a database project after a change has been made to the pre- or post-deployment script, reducing… Read more

SQL Server Data-Tier Application Framework (June 2013) Available

What’s new? This feature release of the Data-Tier Application Framework (DACFx) brings with it a significant payload of both new functionality as well as 100+ bug fixes since the last release. The features included in this update center around a new set of extensibility scenarios and an extended API surface area on top of DACFx…. Read more

Announcing SQL Server Data Tools – June 2013

We are pleased to announce that SQL Server Data Tools – June 2013 is now available for download.  This release introduces several new features that we have consistently received requests for via MSDN forums and Connect.   From the SSDT team, thank you for your valuable feedback and suggestions! Get it here http://msdn.microsoft.com/en-us/data/hh297027 What’s new Data… Read more