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

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

Rate This
  • Comments 15

What’s new?

This update to the Data-Tier Application Framework (DACFx) addresses several high-priority issues reported by DACFx and SQL Server Data Tools customers via the forum and Connect. The issues addressed include:

  • Database Project in Visual Studio hangs on “Analyzing Database Schema…”
    • This release addresses an issue that can occur when loading or building large Database Projects. In some cases, the operation would never finish.
    • This is a functional fix, not a performance enhancement - even with the fix, the time to complete this operation depends on the size and complexity of your project.  

 

  • “System.ObjectDisposedException: Store must be open for this operation” failure in DACFx
    • This release addresses an issue that can occur when simultaneously working over multiple Database Projects or DACFx operations. In some case, an error would be encountered and the operation would not complete.

 

  • “Unexpected failure occurred: hexadecimal value 0xxx, is an invalid character” failure in DACFx
    • This update addresses an issue that can cause the above failure on Export BACPAC and Extract DACPAC operations for certain databases.

The team thanks you for your feedback in reporting these issues!

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 March download page linked above. 

The version of this update is 11.1.2824.1. This supersedes the previously available November release (11.1.2820.0). 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 December 2012 release of  SQL Server Data Tools released on 12/13, available here. This release is also compatible with SSMS of SQL Server 2012 and SQL Server 2012 SP1.

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 5 and type the answer here:
  • Post
  • "fully compatible with the December 2012 release of  SQL Server Data Tools "

    what about SSDT March 2013 released today ?

  • Hey Daniel,

    The December 2012 release is the latest public version of SQL Server Data Tools. The product that was released today was SQL Server Data Tools - Business Intelligence for Visual Studio 2012, or SSDT-BI. SQL Server Data Tools (SSDT) is a distinct toolset from SSDT-BI.

    Thanks,

    Adam

  • I installed the recent Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio 2012 from the following location:

    www.microsoft.com/.../details.aspx

    During the installation, I selected "Include SQL Server product updates."

    I have a VS2012 solution with a database project.  After installing the newest SSDT BI, when I load the solution, I get the following error:

    "Incompatible versions of SQL Server Data Tools and database runtime components are installed on this computer. See go.microsoft.com/fwlink for more details"

    When I try to reload the database project I get the following error:

    "The operation could not be completed.  Unspecified error."

    If I remove the database project from the solution, and add it again, I get the same error as the first error I listed, ""Incompatible versions of SQL Server Data Tools and database runtime components ..."

    I attempted to fix the issue by installing the x64 and x86 new March versions of all the DACfx files at the following location:

    www.microsoft.com/.../details.aspx

    Installing the files from the above link did not fix the issue.   Still have the exact same problem.

    How can I fix this so my solution will correctly load the database project?

  • Hey Todd,

    Thanks for reaching out. After you installed the latest DACFx MSIs are you still getting the "..database runtime components" incompatibility message? Can you check to see what version of Data-Tier Application Framework (DACFx), as well as SQL Server Data Tools (not SSDT-BI) you have installed via Add/Remove Programs?

    Thanks,

    Adam

  • Hi Adam,

    Installing the latest DACFx msi's did not fix the issue.

    My DACFx (both x86 and x64) is 11.1.2824.1

    My SSDT is 11.1.20627.00

  • Todd,

    The current version of SSDT that you have is from VS2012 RTM and is indeed incompatible with the latest DACFx. You will need to update your SSDT to the latest release for Visual Studio 2012 (SSDT - December 2012) available on the SSDT Get It page here - msdn.microsoft.com/.../jj650015.

    This should resolve the incompatibility issue you are facing.

    Thanks,

    Adam

  • @Adam

    "The current version of SSDT that you have is from VS2012 RTM and is indeed incompatible with the latest DACFx. You will need to update your SSDT to the latest release for Visual Studio 2012 (SSDT - December 2012) available on the SSDT Get It page here - msdn.microsoft.com/.../jj650015.

    This should resolve the incompatibility issue you are facing."

    why is this not checked by the installer of DACFx?

    It would save a lot of support cases at MS and even more frustration by us developers.

  • Daniel,

    DACFx is is used by many components and applications, in addition SSDT. The incompatibility is due to breaking changes that were made in the October release of DACFx which require the November (or later) SSDT to be installed. These breaking changes were due to supporting constructs introduced by SQL Server 2012 SP1.

    The error that Daniel is seeing is the check we put into place to notify developers of an incompatibility between the installed versions of SSDT and DACFx and to prevent folks from getting into a bad state. When you see this dialog, the appropriate thing to do is upgrade to the latest SSDT and DACFx, something that can be done within SSDT using the "Check for Updates" feature under the SQL menu inside Visual Studio.

    Thanks,

    Adam

  • When I installing ENU\x64\DACFramework.msi I gave warning that I have latest version, but I install this file.

    In VS2012 I go to SQL - check update -> Microsoft SQL 2012 Data-Tier App framert, Installed 11.1.2824.1, but in latest column  I found 11.1.2820.1. How can I understand it?

  • Why do we have to execute 6 different installers to apply this DACFx update? As as user I'd like to have a single MSI for x64 that would take care of updating all the packages that have to be upgraded. Having to understand which file to download and in the order to execute them should not be necessary.

  • @David - totally agree. Six MSI's covering both 32 and 64 bit? Install them all if you are on a 64 bit machine? C'mon fellas!

  • Installing this update doesn't fix the issue with "Analyzing database schema" causing VS to hang. Now my Visual Studio hangs ever earlier.

  • @Georgi,

    Can you please follow up with me offline at admahood at microsoft dot com? I would like to see if we can try to reproduce this issue and understand why you are still seeing this issue.

    Thanks,

    Adam

  • Running Visual Studio 2012 Premium, in Server Explorer, am unable to create a query or view a table's data. I get the error dialog "An incompatible DacFx version is installed."

    I checked my Add/Remove programs, and I am at version 11.1.2825.1 for the 2012 data-tier apps (x64 and x86) on my x64 Windows 8 machine. I installed all six MSI files, in no particular order. They all finished without error.

    My SQL Server instance is 11.0.3128. My Visual Studio is up to date on patches. I have no updates available in Windows.

    Please advise what I'm supposed to do, to get this working. This is quite frustrating, since all I can find is advice to do what I've already done.

  • Guys, help me out!

    In order to create Database Diagrams inside SQL Server R2 2012 SP1, I MUST have the old engine from VS 2010.

    Why? Because when I installed VS 2012 WITH SSDT that comes with it, I couldn't create these diagrams inside SSMS. Gave me that error about DACx.

    So, I have all those files inside MsDesigner, along with SQL Server and VS 2012 removed, and installed from ground up SQL Server WITH SSDT and VS 2012 WITHOUT SSDT.

    Then I get that error inside VS 2012 when I`m going to use SQL Server Data Tools: incompatibility.

    My question is: IF I upgrade SSDT to meet VS 2012 requirements will it SPOIL my current SSDT installation?

    Regards.

Page 1 of 1 (15 items)