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

  • Article

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 the script in length, may cause corruption of the script.
    • After build, the pre- or post- deployment scripts may contain extra characters or statements that were not on the original user script.
  • Symptom
    • Publishing the database project may fail due to invalid, extraneous characters in the pre- or post-deployment scripts.
    • Examining the deployment script generated during a project Publish operation may show extra characters/statements in the contents of the pre- or post-deployment segments.
  • Resolution
    • Install the updated release of DACFx available here to fix this issue.
    • Once the new version is installed, execute a Clean operation on your database projects and then Rebuild.

How can I get it?

You can obtain this new version of DACFx and its dependencies from our Microsoft Download Center page here. This version of DACFx supersedes all previously available versions. This new version of DACFx supports in-place upgrade from previous versions, so it is not required to remove previous DACFx installations before upgrading to this new release.

The version of this update is 11.1.2864.0. This supersedes the previously available June release (11.1.2861.0). You can determine which version of the Data-Tier Application Framework you currently have installed via Windows Add/Remove Programs or the “Check for Updates” feature in SSDT for Visual Studio 2010/2012.

Compatibility

This release of DACFxis fully compatible with the newly released June 2013 release of SQL Server Data Tools, available here, as well as the Visual Studio 2013 Preview. This release is also compatible with SSMS of SQL Server 2012 and SQL Server 2012 SP1.

Only SQL Server Management Studio that ships with SQL Server 2014 CTP1 should be used with SQL Server 2014 CTP1 (https://www.microsoft.com/en-us/sqlserver/sql-server-2014.aspx). No version of Visual Studio, SQL Server Data Tools, or Data-Tier Application Framework provides support for SQL Server 2014 CTP1. We will continue to invest in SQL Server Data Tools (SSDT) and Data-Tier Application Framework (DACFx) and the tooling will be updated to support future SQL Server and Windows Azure SQL Database releases. 

Note – Packages created with this version of DACFx that contain required deployment contributors are only consumable by this latest release of DACFx.

If you experience any issues or have any feedback, please let us know via the forum or Connect.