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

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

Rate This
  • Comments 11

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. These extensibility scenarios include:

  • New Schema Model API
    • We have introduced a new set of APIs in the DAC namespace that can be used to open, enumerate, and navigate the schema model contained in DAC Packages (.dacpacs/.bacpacs).
    • This API, centered around the TSqlModel class, supports scenarios including hydrating a schema model from a DAC Package, querying an opened model for objects of a certain type, enumerating the properties on a specific object, and traversing relationships between objects.
    • This API allows you to implement custom solutions on top of DACFx and DAC package artifacts like performing additional validation of your database schema and writing custom schema navigation and browsing tools.
  • Deployment Contributor Extensibility
    • This release introduces two extensibility points that allow users to customize the DACFx deployment pipeline to enable custom validation or manipulation of the deployment plan. Supported deployment contributor types include:
      • Deployment Plan Modifier - Extension that runs after the deployment plan has been generated allowing read/write access to the deployment plan, and read-only access to the model comparison results, and source/target schema models
      • Deployment Plan Executor - Extension that runs during deployment allowing read-only access to the deployment plan      
    • Deployment contributors can be executed when deploying via the DacServices API, SqlPackage.exe, or SSDT.
  •  Build Contributor Extensibility
    • Like with the deployment pipeline, this release adds an extensibility point to the DACFx build pipeline.
    • Users can create extensions that run when building a SQL Server database project in Visual Studio or using MSBuild, enabling read-only access to the schema model and all properties/arguments of the build task.

These updated APIs and extensibility mechanisms live in the Microsoft.SqlServer.Dac and Microsoft.SqlServer.Dac.Extensions assemblies that get installed when you install this latest release.

UPDATE 7/2 – Documentation of the key DACFx API namespaces can be found on MSDN here. Additionally, walkthrough samples for the creation of build and deployment contributors can be found in the SSDT documentation here.

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.

If you are on an x64 machine, you will need to install both the x64 and x86 versions of the MSIs from the DACFx June download page linked above.

The version of this update is 11.1.2861.0. This supersedes the previously available May release (11.1.2825.1). You can determine which version of the Data-Tier Application Framework you currently have installed via Windows Add/Remove Programs.

Compatibility

This release of DACFx is fully compatible with the newly released June 2013 release of SQL Server Data Tools, available here. 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 (http://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.

Leave a Comment
  • Please add 5 and 1 and type the answer here:
  • Post
  • Hi,

    Does anyone have an example of how to set up and use Deployment contributors along with the new Deployment Extension Configuration Build Action that has been mentioned above.

    I tried going through this walk through msdn.microsoft.com/.../ee461507(v=vs.100).aspx but it does not work, when I run MSBuild on the VS2012 database .sqlproj file - it looks like the contributor is not running.

    Any help on how to use new ' Deployment Extension Configuration' Build Action would be appreciated.

    Thanks,

    Anjam

  • Do not install this update if you use VS 2010.  It completely breaks 2010.

    Thank you again Microsoft.

  • @Anjam - Walkthroughs and documentation for the new extensibility API and build/deployment contributors will be published soon.

    @Jeff - This release of DACFx is not compatible with previous SSDT releases for the VS2010 shell, please upgrade to the latest version of SSDT. An updated version of SSDT for VS2010 which is compatible with this version of DACFx is available here - msdn.microsoft.com/.../jj650014.

    Thanks,

    Adam

  • Is there an ETA of when the new documentation/examples for the June 2013 Deployment Contributor Extensibility will be available?

  • Yeah, after a few hours of jerking around with it I figured it out on my own.  I came back here to document your product for you.

  • @Jeff/Anjam/cgmt - As mentioned in the update above, documentation of the new/updated DACFx APIs is available on MSDN here - msdn.microsoft.com/.../bb522480.aspx. The core extensibility functionality is contained in the Dac, Model, and Deployment namespaces. Walkthroughs for the creation of build and deployment contributors are also available on the SSDT documentation here - msdn.microsoft.com/.../dn268597(v=vs.103).aspx.

    Thanks,

    Adam

  • Quick Question - is this version of DACFx included in the June 2013 release of SSDT?  Or will I have to install this after installing June 2013 SSDT?

  • @Jeremy - The June DACFx bits are indeed included in the June release of SSDT, no need to do a separate install.

  • Hi,

    Does this update include the registry options mentioned in the below post:

    social.msdn.microsoft.com/.../ssdt-timeout-when-deploying-a-database

    Several of our deployments have failed because of a couple of long running statements.

    Regards,

    Ian

  • In VS 2010, base.PublishMessage sent messages to the output window.  In VS 2012 I've yet to see the messages in the output window.  Are there other settings that are needed to make this happen?

  • Hi,

    Is there any tool for sql database which does the analysis and gives the metrics based on performance,security,efficiency etc...

    Tanks

    Brijesh

Page 1 of 1 (11 items)