SQL Compare in Visual Studio 2022 has stopped working
swePeso
Posts: 3 New member
in SQL Compare
Yesterday and today I have started to get error
Unable to load DLL 'microsoft.data.sqlclient.sni.x64.dll'. The specified module could not be found.
When comparing a database against the project. The error manifests itself when I click "Compare" button.
What do I need to do to fix this?
Unable to load DLL 'microsoft.data.sqlclient.sni.x64.dll'. The specified module could not be found.
When comparing a database against the project. The error manifests itself when I click "Compare" button.
What do I need to do to fix this?
Tagged:
Answers
Copied "Microsoft.Data.SqlClient.SNI.x64.dll" from "C:\Program Files\Microsoft Visual Studio\2022\Professional\Common7\IDE\Extensions\Microsoft\SQLDB\DAC" to "C:\Windows\System32".
Sorry to hear you are having some issues with SQL Compare when utilizing Visual Studio 2022, I was able to locate some similar errors in other tickets when searching for microsoft.data.sqlclient.sni.x64.dll and Visual Studio 2022 and while for a different product, users had success utilizing Visual Studio version 17.5.0 and older so I am curious what version of Visual Studio you are currently using.
Additionally, do you have any event viewer errors whenever this occurs? Could you possibly include the stack trace here for comparison?