SQLCompare.exe suddenly no longer supports SQL Server 2005
LouisSomers
Posts: 23 Bronze 2
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:
We have not updated anything on the build server since it last worked
Here is the log from the last successful run:
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.
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 : Redgate SQL Change Automation: Build<br>2019-09-12T09:17:06.7770475Z Description : Build and test databases with Redgate SQL Change Automation<br>2019-09-12T09:17:06.7770475Z Version : 3.3.0<br>2019-09-12T09:17:06.7770475Z Author : Redgate Software<br>2019-09-12T09:17:06.7770475Z Help : [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 licensing@red-gate.com<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 at RedGate.SQLToolsCommandLine.CommandProcessor.FatalExceptionHelper(String message, Exception ex)<br>2019-09-12T09:17:30.7998596Z at RedGate.SQLToolsCommandLine.CommandProcessor.RunComparison()<br>2019-09-12T09:17:30.7998596Z at RedGate.SQLToolsCommandLine.CommandProcessor.Run()<br>2019-09-12T09:17:30.7998596Z Caused by:<br>2019-09-12T09:17:30.7998596Z <b>SQL Server 2005 and earlier databases are not supported.</b><br>2019-09-12T09:17:30.7998596Z RedGate.SQLCompare.Engine.UnsupportedSqlServerVersionException<br>2019-09-12T09:17:30.7998596Z at RedGate.SQLCompare.Engine.Registration.SQLVersionExtensions.AssertSupportedVersion(SQLVersion sqlVersion)<br>2019-09-12T09:17:30.7998596Z at RedGate.SQLCompare.Engine.Registration.ModelFactory.DatabaseFactory.CheckForUnsupportedVersions()<br>2019-09-12T09:17:30.7998596Z at RedGate.SQLCompare.Engine.Registration.ModelFactory.DatabaseFactory.Populate(DBPopulationOptions popOptions)<br>2019-09-12T09:17:30.7998596Z 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 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 at RedGate.SQLCompare.Engine.Database.<>c__DisplayClass120_0.<Register>b__0()<br>2019-09-12T09:17:30.7998596Z at RedGate.SQLCompare.Engine.Utils.GetTimeToRun(Action action)<br>2019-09-12T09:17:30.7998596Z at RedGate.SQLCompare.Engine.Database.Register(LiveConnectionInstructions connectionDetails, Nullable`1 optionsParam, IDmvModelFactory factory)<br>2019-09-12T09:17:30.7998596Z at RedGate.SQLCompare.Common.CompareEngineExecutor`1.DoRegisterDatabaseForCompare(Database database, LiveDatabaseSource dataSource)<br>2019-09-12T09:17:30.7998596Z at RedGate.Legacy.ProgressTasks.ProgressTask.ExecuteSubTasks()<br>2019-09-12T09:17:30.7998596Z at RedGate.Legacy.ProgressTasks.SimpleProgressTaskExecutor.DoTasks()<br>2019-09-12T09:17:30.7998596Z 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 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 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 at RedGate.Versioning.Automation.PowerShell.Commands.SyncDatabaseSchemaCommandImpl.GetSyncResult(IAutomationInput source, WarningSeverity abortOnWarningLevel)<br>2019-09-12T09:17:30.7998596Z at RedGate.Versioning.Automation.PowerShell.Commands.SyncDatabaseSchemaCommandImpl.Begin()<br>2019-09-12T09:17:30.7998596Z at RedGate.Versioning.Automation.PowerShell.DlmAutomationCommandImpl`1.BeginProcessing()<br>2019-09-12T09:17:30.7998596Z 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 : Redgate SQL Change Automation: Build<br>2019-09-10T12:13:13.6417300Z Description : Build and test databases with Redgate SQL Change Automation<br>2019-09-10T12:13:13.6417300Z Version : 3.3.0<br>2019-09-10T12:13:13.6417300Z Author : Redgate Software<br>2019-09-10T12:13:13.6573555Z Help : [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 licensing@red-gate.com<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
-
Russell D
Posts: 1,324 Diamond 5
If set to latest, then yes it will pull the latest release from the gallery - pegging it to a particular version as you did is the appropriate course of action in this case.Have you visited our Help Centre?
Answers
Does the automation update itself automatically? Everyone here denies updating anything on the server.