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.

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 DACFxis 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.

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

Todd

8 Mar 2013 11:47 AM

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

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:

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?

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

Daniel

9 Mar 2013 4:31 AM

@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.

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

Oleg

18 Mar 2013 2:51 PM

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?

David

21 Mar 2013 4:54 AM

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.

John

21 Mar 2013 5:51 PM

@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!

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

Mark50266

20 May 2013 9:56 AM

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.