Geek Answers Handbook

Bacpac import error using Sql Server Management Studio 2016 - Failed to load Microsoft.SqlServer.Dac file or assembly

I made a .bacpac file from the Azure portal and saved it to my desktop. Then, in the Studio Studio 2016 editor, right-click on Databases and select "Import Data-Tier Application". I aim at my file, then the following ... and when it goes to the process, I get an error message:

Could not load file or assembly "Microsoft.SqlServer.Dac, Version = 13.0.0.0, Culture = neutral, PublicKeyToken = b03f5f7f11d50a3a" or one of its dependencies. You cannot find the specified file. (Microsoft.SqlServer.Management.Dac.DacWizard)

I searched Google, but I could not find any working solution on it. Could you help me?

Also check out this configuration image:

SQL configuration

+7
sql-server ssms ssdt
source share
2 answers

This is due to a bug in SSMS that needs to be fixed in a future version. The problem is that if you have Lightswitch installed for VS2015, the binding paths used by SSMS to search for DLLs will contain a link to an earlier version of the DacFx DLL from version 130 to version 130. This leads to the above error, because by default Visual Studio returns first matching dll.

Decision:

  • Open "C: \ Program Files (x86) \ Microsoft SQL Server \ 130 \ Tools \ Binn \ ManagementStudio \ ssms.pkgundef" in the text file viewer. You will need to run this viewer as Administrator in order to edit it.

  • Add the following line to ensure that the binding path 110 is ignored in the future and the file is saved:

    [$ $ root partition \ BindingPaths \ {272EA915-68EE-4AFD-99A4-1286126565EC}]

  • Next, we need to remove it from the registry, since it has already been added once. Open Regedit.exe and go to "HKEY_CURRENT_USER \ SOFTWARE \ Microsoft \ SQL Server Management Studio \ 13.0_Config \ BindingPaths"

  • Delete the folder {272EA915-68EE-4AFD-99A4-1286126565EC} from under this key.

Note This will only happen on machines with VS2015 and Lightswitch installed. The reason is that VS2015 binding paths are included in isolated shell applications such as SSMS if the pkgundef file does not exclude them. The fix will be included in an upcoming release.

Disclosure: I am working on the SQL Server toolkit.

+11
source share

You can download the latest version of the data-level application platform (which includes Microsoft.SqlServer.Dac) here: https://www.microsoft.com/en-us/download/details.aspx?id=51672

Please note that you must also install the SqlDom and SqlSysClrTypes dependencies in the "System Requirements" section of the download page:

Dependencies The Microsoft SQL Server application platform for the data tier requires the Microsoft CLR types Microsoft SQL Server and SQL Server SQL Server SQL Server and SQLDys.msi, which are available below. If you are on an x64 machine, you will need to install both x64 and x86 versions of MSI above.

0
source share

More articles:


All Articles