Offical team blog for SSDT, a tool for on and off-premise database development
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:
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.
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.
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.
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.
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.
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.
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.
Does this update include the registry options mentioned in the below post:
Several of our deployments have failed because of a couple of long running statements.
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?
Is there any tool for sql database which does the analysis and gives the metrics based on performance,security,efficiency etc...