Search code examples
sql-serverspring-boothsqldbflyway

Migration from Spring Boot 2.6 to 2.7 - FlywayException: Unsupported Database: Microsoft SQL Server 15.0

During migration of a Java app using Spring Boot 2.6 to 2.7, new Flyway version (8.5.13) seems to not support anymore SQL Server 15 (2019).

Error org.flywaydb.core.api.FlywayException: Unsupported Database: Microsoft SQL Server 15.0

I try with older version of SQL Server 14 (2017) and get almost same error

Error org.flywaydb.core.api.FlywayException: Unsupported Database: Microsoft SQL Server 14.0

Somebody already resovled this problem?

UPDATE 2025

Same problem happened with HSQLDB during migration from Spring Boot 3.2 to 3.3.

Error org.flywaydb.core.api.FlywayException: Unsupported Database: HSQL Database Engine 2.7

Same fix, add new flyway dependency flyway-database-hsqldb

Solution

  • The SQL Server code was extracted to a separate dependency in Flyway 8.1.0

    From that release onwards, you will need to add flyway-sqlserver as an additional dependency, e.g.:

    # Maven
<dependency>
    <groupId>org.flywaydb</groupId>
    <artifactId>flyway-sqlserver</artifactId>
</dependency>

# Gradle
dependencies {
    compile "org.flywaydb:flyway-sqlserver"
}