Skip to content

V6 migration script for SQL Server fails #5276

@sbklahr

Description

@sbklahr

Bug description
I'm migrating from Spring Batch 5.2.4 to 6.02 with an existing SQL server database.

The initial schema was created using schema-sqlserver.sql in version 5.2.4. When executing migration-sqlserver.sql in version 6.0.2 the following sql error is thrown:

Failed SQL: (5074) The object "JOB_INST_UN" is dependent on column "JOB_NAME"

when executing ALTER TABLE BATCH_JOB_INSTANCE ALTER COLUMN JOB_NAME NVARCHAR(100) NOT NULL; from the migration script.

Environment
Spring Batch 6.0.2, SQL Server 15.0.4455

Steps to reproduce
Execute the initial schema for schema-sqlserver.sql in version 5.2.4. Then execute migration-sqlserver.sql in version 6.0.2

Expected behavior
The migration should be executed without errors.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions