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
2 Replies
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.
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.
