Getting error after adding a migration script

Hi Team,

I am using SQL Source Control 5 to link my database with TFVC.

I did a fresh build after linking the database, it was successful. Then I renamed a table and added a migration script and committed to source control. After this the build is failing with below error. Kindly suggest any solution for the same.



[error]SQLCompare.exe terminated with the exit code 255.

[error]SQLCompare.exe produced this error output:

[error]Error: Comparison of 'Scripts.PlugIn' and 'np:\\.\pipe\LOCALDB#B2CCC787\tsql\query.dlmautomation_16dd6cdd-77af-4d71-93f4-038780ac92a3' failed: The type initializer for 'LibGit2Sharp.Core.NativeMethods' threw an exception.

[error]Unhandled Exception: System.TypeInitializationException: The type initializer for 'LibGit2Sharp.Core.NativeMethods' threw an exception. ---> System.DllNotFoundException: Unable to load DLL 'git2-a5cf255': Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

[error] at LibGit2Sharp.Core.NativeMethods.git_libgit2_init()

[error] at LibGit2Sharp.Core.NativeMethods.LibraryLifetimeObject..ctor()

[error] at LibGit2Sharp.Core.NativeMethods..cctor()

[error] --- End of inner exception stack trace ---

[error] at LibGit2Sharp.Core.NativeMethods.RemoveHandle()

[error] at LibGit2Sharp.Core.NativeMethods.LibraryLifetimeObject.Finalize()

[error]Unable to upload artifact from:D:\cccharv\agent1\_work\29\s\PlugIn.20171011.9.nupkg



Finishing task: RedgateDlmAutomationBuild

Please help.

Thanks!



I didn't find the right solution from the Internet.



References:
 forum.red-gate.com/discussion/81919/getting-error-after-adding-a-migration-script



animation videos