Azure Synapse (Fabric) - Unknown SQL Server engine edition: 11

ds_cc

Attempting to connect into an Fabric instance of Azure Synapse (Microsoft Azure SQL Data Warehouse (RTM) - 12.0.2000.8) and receiving the following error:

Flyway OSS Edition 10.20.1 by Redgate

See release notes here: https://rd.gt/416ObMi
ERROR: java.lang.IllegalArgumentException: Unknown SQL Server engine edition: 11

Peter_Laws

Hello ds_cc,

I'm sorry to read you hit this issue.
The cause of that error is because you're using serverless SQL pool with Synapse which Flyway doesn't support. The Dedicated pool variant is supported.