SQLCompare.exe suddenly no longer supports SQL Server 2005

In our build automation we have a step that checks backward compatibility with older SQL Server versions. Two days ago it ran successfully. Now after checking in a small change it throws an error. Here's the TFS log with the error:

2019-09-12T09:17:06.7770475Z ##[section]Starting: Sync VMSII SQL2005<br>2019-09-12T09:17:06.7770475Z ==============================================================================<br>2019-09-12T09:17:06.7770475Z Task&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : Redgate SQL Change Automation: Build<br>2019-09-12T09:17:06.7770475Z Description&nbsp; : Build and test databases with Redgate SQL Change Automation<br>2019-09-12T09:17:06.7770475Z Version&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : 3.3.0<br>2019-09-12T09:17:06.7770475Z Author&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : Redgate Software<br>2019-09-12T09:17:06.7770475Z Help&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : [More Information](https://www.red-gate.com/sca/ps/help)<br>2019-09-12T09:17:06.7770475Z ==============================================================================<br>2019-09-12T09:17:06.7770475Z Preparing task execution handler.<br>2019-09-12T09:17:07.0959944Z Executing the powershell script: D:\Agents\1\_work\_tasks\RedgateSqlChangeAutomationBuild_7345fe1b-d099-46f0-a0d1-7292cd17feee\3.3.0\SqlChangeAutomationBuild.ps1<br>2019-09-12T09:17:13.4733097Z Setting ErrorActionPreference to "Stop" because no -ErrorAction argument was provided<br>2019-09-12T09:17:13.6764381Z New-DatabaseConnection, SQL Change Automation 4.0.19254.10484, Copyright © Red Gate Software Ltd 2014-2019<br>2019-09-12T09:17:13.6920636Z Use of this functionality requires a SQL Toolbelt license.<br>2019-09-12T09:17:13.6920636Z If you are unsure of your current user license entitlement please contact [email protected]<br>2019-09-12T09:17:13.8326919Z Sync-DatabaseSchema, SQL Change Automation 4.0.19254.10484, Copyright © Red Gate Software Ltd 2014-2019<br>2019-09-12T09:17:23.2365551Z ##[warning]filter file 'D:\BuildTools\FilterRulesRedGate.scpf' specified by the FilterPath parameter is overriding the filter in SQL Source Control build artifact file 'D:\Agents\1\_work\13\s\VMSII.1.0.21224.nupkg' in the source.<br>2019-09-12T09:17:30.7998596Z ##[error]RedGate.Versioning.Automation.Shared.Errors.TerminatingException: SQLCompare.exe terminated with the exit code 126: Failed due to a SQL Server error.<br>2019-09-12T09:17:30.7998596Z SQLCompare.exe produced this error output:<br>2019-09-12T09:17:30.7998596Z Error: Comparison of 'Scripts.finb4cu1.vr0' and 'DEV-SQL-OLD\SQL2005.Schema_Compare_DEV_VMSII_NET' failed: SQL Server 2005 and earlier databases are not supported.<br>2019-09-12T09:17:30.7998596Z Comparison of 'Scripts.finb4cu1.vr0' and 'DEV-SQL-OLD\SQL2005.Schema_Compare_DEV_VMSII_NET' failed: <b>SQL Server 2005 and earlier databases are not supported.</b><br>2019-09-12T09:17:30.7998596Z RedGate.Legacy.CommandLine.FatalExecutionException<br>2019-09-12T09:17:30.7998596Z&nbsp;&nbsp;&nbsp; at RedGate.SQLToolsCommandLine.CommandProcessor.FatalExceptionHelper(String message, Exception ex)<br>2019-09-12T09:17:30.7998596Z&nbsp;&nbsp;&nbsp; at RedGate.SQLToolsCommandLine.CommandProcessor.RunComparison()<br>2019-09-12T09:17:30.7998596Z&nbsp;&nbsp;&nbsp; at RedGate.SQLToolsCommandLine.CommandProcessor.Run()<br>2019-09-12T09:17:30.7998596Z Caused by:<br>2019-09-12T09:17:30.7998596Z&nbsp;&nbsp; <b>SQL Server 2005 and earlier databases are not supported.</b><br>2019-09-12T09:17:30.7998596Z&nbsp;&nbsp; RedGate.SQLCompare.Engine.UnsupportedSqlServerVersionException<br>2019-09-12T09:17:30.7998596Z&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at RedGate.SQLCompare.Engine.Registration.SQLVersionExtensions.AssertSupportedVersion(SQLVersion sqlVersion)<br>2019-09-12T09:17:30.7998596Z&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at RedGate.SQLCompare.Engine.Registration.ModelFactory.DatabaseFactory.CheckForUnsupportedVersions()<br>2019-09-12T09:17:30.7998596Z&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at RedGate.SQLCompare.Engine.Registration.ModelFactory.DatabaseFactory.Populate(DBPopulationOptions popOptions)<br>2019-09-12T09:17:30.7998596Z&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at RedGate.SQLCompare.Engine.Registration.ModelFactory.DatabaseFactory.RegisterFromFactory(Database database, Options options, Boolean includeViewColumnDetails, DatabaseFactory databaseFactory, String databaseName)<br>2019-09-12T09:17:30.7998596Z&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at RedGate.SQLCompare.Engine.Registration.ModelFactory.DatabaseFactory.RegisterFromLive(Database database, LiveConnectionInstructions connectionDetails, Options options, IDmvModelFactory dmvModelFactory, Boolean includeViewColumnDetails)<br>2019-09-12T09:17:30.7998596Z&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at RedGate.SQLCompare.Engine.Database.<>c__DisplayClass120_0.<Register>b__0()<br>2019-09-12T09:17:30.7998596Z&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at RedGate.SQLCompare.Engine.Utils.GetTimeToRun(Action action)<br>2019-09-12T09:17:30.7998596Z&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at RedGate.SQLCompare.Engine.Database.Register(LiveConnectionInstructions connectionDetails, Nullable`1 optionsParam, IDmvModelFactory factory)<br>2019-09-12T09:17:30.7998596Z&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at RedGate.SQLCompare.Common.CompareEngineExecutor`1.DoRegisterDatabaseForCompare(Database database, LiveDatabaseSource dataSource)<br>2019-09-12T09:17:30.7998596Z&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at RedGate.Legacy.ProgressTasks.ProgressTask.ExecuteSubTasks()<br>2019-09-12T09:17:30.7998596Z&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; at RedGate.Legacy.ProgressTasks.SimpleProgressTaskExecutor.DoTasks()<br>2019-09-12T09:17:30.7998596Z&nbsp;&nbsp;&nbsp; at RedGate.Versioning.Automation.Compare.RedgateTools.CompareResultExtensions.HandleCompareResult(RedgateToolResult redgateToolResult, ILog log, Object targetObject, String executable, Nullable`1 overrideReport)<br>2019-09-12T09:17:30.7998596Z&nbsp;&nbsp;&nbsp; at RedGate.Versioning.Automation.Compare.Compare.CompareUpdateGenerator.GetUpdateFrom(ISchemaSource sourceSchema, ISchemaSource targetSchema, Filter filter, SqlCompareOptions options, TransactionIsolationLevel transactionIsolationLevel, Boolean includeStaticData, Boolean ignoreAdditional, Boolean ignoreParserErrors)<br>2019-09-12T09:17:30.7998596Z&nbsp;&nbsp;&nbsp; at RedGate.Versioning.Automation.Compare.Commands.DatabaseSchemaSynchronizer.SyncSchema(ISchemaSource schemaSource, DatabaseConnection target, CompareOptionArguments compareOptionArguments, TransactionIsolationLevel transactionIsolationLevel, Boolean ignoreStaticData, Boolean ignoreAdditional, WarningSeverity abortOnWarningLevel, Int32 queryBatchTimeout)<br>2019-09-12T09:17:30.7998596Z&nbsp;&nbsp;&nbsp; at RedGate.Versioning.Automation.PowerShell.Commands.SyncDatabaseSchemaCommandImpl.GetSyncResult(IAutomationInput source, WarningSeverity abortOnWarningLevel)<br>2019-09-12T09:17:30.7998596Z&nbsp;&nbsp;&nbsp; at RedGate.Versioning.Automation.PowerShell.Commands.SyncDatabaseSchemaCommandImpl.Begin()<br>2019-09-12T09:17:30.7998596Z&nbsp;&nbsp;&nbsp; at RedGate.Versioning.Automation.PowerShell.DlmAutomationCommandImpl`1.BeginProcessing()<br>2019-09-12T09:17:30.7998596Z&nbsp;&nbsp;&nbsp; at RedGate.PowerShell.CommandBase`2.DelegateTo(Action doImplementation)<br>2019-09-12T09:17:30.8154840Z ##[error]PowerShell script completed with 1 errors.<br>2019-09-12T09:17:30.8154840Z ##[section]Finishing: Sync VMSII SQL2005

We have not updated anything on the build server since it last worked
Here is the log from the last successful run:

2019-09-10T12:13:13.6417300Z ##[section]Starting: Sync VMSII SQL2005<br>2019-09-10T12:13:13.6417300Z ==============================================================================<br>2019-09-10T12:13:13.6417300Z Task&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : Redgate SQL Change Automation: Build<br>2019-09-10T12:13:13.6417300Z Description&nbsp; : Build and test databases with Redgate SQL Change Automation<br>2019-09-10T12:13:13.6417300Z Version&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : 3.3.0<br>2019-09-10T12:13:13.6417300Z Author&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : Redgate Software<br>2019-09-10T12:13:13.6573555Z Help&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; : [More Information](https://www.red-gate.com/sca/ps/help)<br>2019-09-10T12:13:13.6573555Z ==============================================================================<br>2019-09-10T12:13:13.6573555Z Preparing task execution handler.<br>2019-09-10T12:13:13.9698650Z Executing the powershell script: D:\Agents\2\_work\_tasks\RedgateSqlChangeAutomationBuild_7345fe1b-d099-46f0-a0d1-7292cd17feee\3.3.0\SqlChangeAutomationBuild.ps1<br>2019-09-10T12:13:20.6648795Z Setting ErrorActionPreference to "Stop" because no -ErrorAction argument was provided<br>2019-09-10T12:13:20.8992591Z New-DatabaseConnection, SQL Change Automation 4.0.19246.10328, Copyright © Red Gate Software Ltd 2014-2019<br>2019-09-10T12:13:20.8992591Z Use of this functionality requires a SQL Toolbelt license.<br>2019-09-10T12:13:20.8992591Z If you are unsure of your current user license entitlement please contact [email protected]<br>2019-09-10T12:13:21.0555117Z Sync-DatabaseSchema, SQL Change Automation 4.0.19246.10328, Copyright © Red Gate Software Ltd 2014-2019<br>2019-09-10T12:13:30.8318347Z ##[warning]filter file 'D:\BuildTools\FilterRulesRedGate.scpf' specified by the FilterPath parameter is overriding the filter in SQL Source Control build artifact file 'D:\Agents\2\_work\38\s\VMSII.1.0.21214.nupkg' in the source.<br>2019-09-10T12:13:56.7616103Z ##[warning](Low) Creating statistics [hind_1440724185_4_1_6_5_3] on [dbo].[T_PRODUCT_STOCK]. When deploying statistics, the SAMPLE option isn't supported. If you're deploying statistics that use SAMPLE, you'll need to manually modify the deployment script for those objects.<br>2019-09-10T12:13:57.7501772Z ##[section]Finishing: Sync VMSII SQL2005

Does SqlCompare.exe have a built-in trigger to stop supporting SQL Server 2005 on 9-11-2019 or something like that?
We are sure that it was not (manually) updated.
Tagged:

Best Answer

Answers

  • LouisSomersLouisSomers Posts: 12 Bronze 1
    edited September 12, 2019 10:15AM
    We got it working again by using "4.0.19246.10328" in the "Required version of SQL Change Automation" field. It was set to "Latest" previously.

    Does the automation update itself automatically? Everyone here denies updating anything on the server.
Sign In or Register to comment.