How can we help you today? How can we help you today?

SQL Compare in Visual Studio 2022 has stopped working

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?
Peter
0

Comments

2 comments

Sort by
  • swePeso
    Made a temporary fix.
    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".
    swePeso
    0
  • cperez
    Hi SwePeso,

    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?
    cperez
    0

Add comment

Please sign in to leave a comment.