RedGate - Comparison of 'Scripts.RedGate' and database fail during code deploy
GHoh
Posts: 5 New member
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
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
Tagged:
Answers
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
Have you visited our Help Center?