RedGate - Comparison of 'Scripts.RedGate' and database fail during code deploy

GHoh

During a deploy of a new release to our production server, the RedGate migration failed with an error shown below.  I've not found a post on your forum that helps us to better understand the error and find a resolution.

This same release of code was deployed to our staging website without RedGate errors occurring.  

Can anyone suggest how we can research this script error?

Thank you in advance

Error: Comparison of 'Scripts.RedGate' and 'ourserver.ourdatabase' failed: Scripts Folder

Running redgate SqlCompare
SQL Compare Command Line V12.4.12.5042
==============================================================================
Copyright c 1999 - 2017 Redgate Software Ltd

Argument /scripts1 has value 'RedGate'
Argument /server2 has value 'xxx'
Argument /database2 has value 'xxx'
Argument /username2 has value 'xxxx'
Argument /password2 has value 'xxxx'
Argument /include has value 'StaticData'
Argument /options has value 'IgnoreUsersPermissionsAndRoleMemberships'
Argument /verbose has value 'True'
Argument /synchronize has value 'True'

Found client endpoint at net.tcp://127.0.0.1:22222/activationplugin/
Redgate Client capability version: 2
SQL Compare: activated, edition professional, serial number: 0
SQL Compare running with option: IgnoreUsersPermissionsAndRoleMemberships (OK).
Comparing database Scripts.RedGate with database xxx.xxx...
Registering data sources
Warning: Ignored statement found in file C:\Jenkins\jobs\spendbridge-legacy prod
deploy tag Webxx and
migrations\workspace\Build\Publish\RedGate\Data\dbo.LocalizedLabels_Data_invoice
-edit.sql at line 1
Warning: If statement in file C:\Jenkins\jobs\spendbridge-legacy prod deploy tag
Web02 and
migrations\workspace\Build\Publish\RedGate\Data\dbo.LocalizedLabels_Data_invoice
-edit.sql at line 3 considered as true
Warning: Ignored statement found in file C:\Jenkins\jobs\spendbridge-legacy prod
deploy tag Webxx and
migrations\workspace\Build\Publish\RedGate\Data\dbo.LocalizedLabels_Data_invoice
-edit.sql at line 5
Warning: Ignored statement found in file C:\Jenkins\jobs\spendbridge-legacy prod
deploy tag Webxx and
migrations\workspace\Build\Publish\RedGate\Data\dbo.LocalizedLabels_Data_invoice
-edit.sql at line 6
Warning: Ignored statement found in file C:\Jenkins\jobs\spendbridge-legacy prod
deploy tag Webxx and
migrations\workspace\Build\Publish\RedGate\Data\dbo.LocalizedLabels_Data_invoice
-edit.sql at line 13
Warning: Ignored statement found in file C:\Jenkins\jobs\spendbridge-legacy prod
deploy tag Webxx and migrations\workspace\Build\Publish\RedGate\Stored
Procedures\Integration.GetQueuedItems.sql at line 1
Creating mappings
Comparing

Applying Command Line Items

Error: Comparison of 'Scripts.RedGate' and 'server.db' failed: Scripts Folder

Alex B

Hi @GHoh,

Can you elaborate a bit more on your process here?  Are you deploying from SQL Source Control using DLM Automation or SQL Change Automation or just the SQL Compare cmd line?

Also, what versions are the different target SQL instances that worked and that did not?  You are using version 12.4 of SQL Compare so there could be version incompatibility.

Kind regards,
Alex