New version of Data-Tier Application framework is available


If you have handled the DAC packages from SQL Server 2008 R2 for your database update deployments, then you will know about Data-Tier Framework. However, here is brief explanation from the source:

    The Microsoft® SQL Server® 2012 Data-Tier Application Framework (DACFx) is a component which provides application lifecycle services for database development and management for Microsoft® SQL Server® and Windows Azure SQL Databases.
    DacFX supports various database deployment and management scenarios for SQL Server and Windows Azure SQL Databases including extracting/exporting a live database to a DAC package, deploying a DAC package to a new or existing database, and migrating from on-premise SQL Server to Windows Azure. This functionality is exposed via the DACFx managed API. DACFx can target SQL Server 2005 SP4, 2008 SP1, 2008R2, 2012, and Windows Azure SQL Databases. DACFx also provides the command-line utility SqlPackage.exe for creating and deploying .dacpac and .bacpac packages. DACFx supports scenarios provided by SQL Server client tooling including SQL Server Data Tools and SQL Server Management Studio 2012.

SQL Server Data Tools blog confirms the latest update:

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.

The next big question is how to obtain the package update or this new version, the new version can be downloaded from this DACFx package @ Microsoft Downloads page. The important point that you need to ensure is this version of DACFx supersedes the previous available versions. This means you can directly upgrade from the previous versions as an in-place upgrade. The new version is 11.1.2864, in order to obtain the currently installed DACFx version you can go to Add/Remove programs and look for SSDT for Visual Studio 2010/2012 program.

SSDT blog post confirms that: This release of DACFx is 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.