What are the challenges you face when working across database platforms? Take the survey

Build a SQL Source Control project error

Hi All

I've been struggling setting up a CI project and I've gotten to the piece where you create a pipeline to make sure it will run successfully.  The error I'm getting is:

SQLCompare.exe terminated with the exit code 74: I/O error.
Encountered an error when trying to read from or write to a file.
SQLCompare.exe produced this error output:
Error: Could not load file or assembly 'RedGate.Database.BlockDeployment.Synchronizer.DeploymentLog.SqlServer, Version=, Culture=neutral, PublicKeyToken=7f465a1c156d4d57' or one of its dependencies. The system cannot find the file specified.

I have the SQL Toolbelt installed on the SQL Db server and the file does exist. 
I've made sure that the account that is running the build has access to the Redgate folders with full control 

I can't find anything that can help me get past this.  Has anyone else encountered this when setting up their CI?


  • Options
    Maziar_ChitsazMaziar_Chitsaz Posts: 4 New member
    Hi Cat

    I have the same problem and tried these (below) but nothing is changed:

    - Remove Agent and Install it Again
    - Completely uninstall SQL Toolbelt and reinstall it.
    - Checked to be sure that I'm using latest version of tools and add-ons.

Sign In or Register to comment.