Does SQL CI work with SQL Server 2005

belgrave

I want to run SQL CI using Jenkins against a SQL Server 2005 to do compatiability checks on commits.

Is this possible as im getting the following error in the Jenkins logs on a clean database:

Inserting static data SQL into deployment script
Deploying changes (from DB1 to DB2)
Error: Synchronization of 'Scripts.state' and 'jupdevsvr1.CHECK_2005_COMPILATION_CI' failed: Transaction (Process ID 51)
was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Error executing the following SQL: CREATE FUNCTION [dbo].[func_MyFunction](@StartDate DATETIME =NULL ,@TaxId INT = NULL)
RETURNS @Tax TABLE (TaxId INT ,[Name] VARCHAR(50) ,[Description] VARCHAR(200) ,[Value] ...
Validating database state failed with error: SQLCompare failed with exit code 126: see output above for more information, or for generic information about this exit code, see: http://www.red-gate.com/sqlCI/ExitCodes/SQLCompare
FINISHED WITH ERROR: Validating database state
Running SQLCompare failed with error: SQLCompare failed with exit code 126: see output above for more information, or for generic information about this exit code, see: http://www.red-gate.com/sqlCI/ExitCodes/SQLCompare
Build step 'Redgate DLM Automation: Build a database package' marked build as failure
Successfully triggered JIRA to update builds of this job
Finished: FAILURE

Sergio R

Hi,

I am sorry to say but the DLM Automation tools do not support SQL Server 2005.

For more information please see the requirements page: https://documentation.red-gate.com/disp ... quirements

Thank you,

belgrave

Thanks Sergio. Hopefully we dont have to support 2005 for much longer anyway.