Forum Discussion
SSMS 21/22 Error Upload BACPAC file to Azure Storage
Hello All
In my SSMS 20, I can use "Export Data-tier Application" to export an BACPAC file of Azure SQL database and upload to Azure storage
in the same machine, the SSMS 21 gives error message when doing the same export, it created the BACPAC files but failed on the last step, "Uploading BACPAC file to Microsoft Azure Storage", The error message is "Could not load file or assembly 'System.IO.Hashing, Version=6.0.0.0, Culture=neutral, PublicKeyToken=cc7b13ffcd2ddd51' or one of its dependencies. The system cannot find the file specified. (Azure.Storage.Blobs)"
I tried the fresh installation of SSMS 21 in a brand-new machine (Windows 11), same issue,
Can anyone advice?
Thanks
5 Replies
- matteo_taveggia
Microsoft
This is indeed a bug in SSMS.
The suggested workaround is not helpful, however it point you in the right direction, in case you are blocked and you don't want to wait for a release of SSMS with the fix I'm preparing.
You just need to download the package from https://www.nuget.org/packages/System.IO.Hashing/6.0.0 rename it to .zip, unzip it and grab trhe System.IO.Hashing.dll you find under the lib/net461 folder. Copy it to the <SSMS_Install_Path>\Common7\IDE of your machine... Close and reopen SSMS and you should be good to go.
For reference, the easiest way to get in touch with us (SSMS Product Team and the rest of the SSMS community is to report the issue directly via the SSMS UI: just use the menu "Help | Send Feedback | Report a Problem" and fill out the form. Doing so would allow the SSMS community to see the issue, upvote it and be notified when a fix is available. Keep that in mind for the future!- Man Lam ChengCopper Contributor
Thank you! it works
Same bug existed in V21, don't understand why still not fixed in V22
I will report the bug using Help menu in the future
Thanks
- matteo_taveggia
Microsoft
Simply because.... this is not a a forum we (SSMS Team) check for issues reported by users.
For that reason, it was missed.
I fixed it in our mainline branch, so you should expect the change in SSMS 22.x "soon" (either the next update or the one after that)
This seems like a bug. Here are some workarounds.
If the issue is getting that package, you can try:
dotnet add package System.IO.Hashing --version 6.0.0If you don’t need features from Azure.Storage.Blobs ≥12.17.0, you can downgrade to 12.12.0, which doesn’t depend on System.IO.Hashing:
dotnet add package Azure.Storage.Blobs --version 12.12.0No guarantees about version numbers, but if you have a clean machine to try, experiment with different values.
Hope this helps.
- Man Lam ChengCopper Contributor
This command needs to be ran in a project directory, I am simply just want to backup the database. Not sure how to do this for the whole system.