Flyway does not support Azure Arc SQL server

[eliufen2020]

Hi Flyway team,
When we use Flyway with latest version to connect to Azure Arc SQL server, it failed!
The Azure Arc Images we used include:
mcr.microsoft.com/arcdata/arc-sqlmi:v1.29.0_2024-04-09
mcr.microsoft.com/arcdata/arc-monitor-collectd:v1.29.0_2024-04-09
mcr.microsoft.com/arcdata/arc-ha-supervisor:v1.29.0_2024-04-09
mcr.microsoft.com/arcdata/arc-monitor-fluentbit:v1.29.0_2024-04-09

I wonder whether or not Flyway support Azure Arc SQL server?
Could you please take a look. Your advice is great appreciated!

Error Logs:

[JasonLuo-Redgate]

Hi @eliufen2020 ,

Many thanks for reporting this issue to us.

The error log indicates that the returned Engine Edition value is 10, which is not currently supported by Flyway.

The Engine Edition values currently supported by Flyway are: 1,2,3,4,5,6,8,9 (referring to

flyway/flyway-database/flyway-sqlserver/src/main/java/org/flywaydb/database/sqlserver/SQLServerEngineEdition.java

Line 31 in 1019797

public enum SQLServerEngineEdition {

)

More info about Engine Edition:
https://learn.microsoft.com/en-us/sql/t-sql/functions/serverproperty-transact-sql?view=sql-server-ver16

[eliufen2020]

Hi @JasonLuo-Redgate
Thank you for your analysis, I display the version of SQL server, it seems Microsoft Azure SQL Managed Instance should belong to the engine edition 8? does FLYWAY plan to support it?

sqlcmd -C -S localhost -U abc -d abc-edge-0 -Q "SELECT @@Version;"

---

Microsoft Azure SQL Managed Instance - Azure Arc - 16.0.5290.8214 (X64)
Mar 25 2024 07:48:30
Copyright (C) 2022 Microsoft Corporation
General Purpose (64-bit) on Linux (Ubuntu 20.04.6 LTS)

(1 row affected)

Database Engine edition of the instance of SQL Server installed on the server.
1 = Personal or Desktop Engine (Not available in SQL Server 2005 (9.x) and later versions.)
2 = Standard (For Standard, Web, and Business Intelligence.)
3 = Enterprise (For Evaluation, Developer, and Enterprise editions.)
4 = Express (For Express, Express with Tools, and Express with Advanced Services)
5 = SQL Database
6 = Azure Synapse Analytics
8 = Azure SQL Managed Instance
9 = Azure SQL Edge (For all editions of Azure SQL Edge)
11 = Azure Synapse serverless SQL pool

[JasonLuo-Redgate]

Yes, if Engine Edition is 8, Flyway should work.

[eliufen2020]

But Flyway did not work. I wonder whether your team will take a look at the issue? If Microsoft Azure SQL Managed Instance - Azure Arc - 16.0.5290.8214 (X64) belong to engine edition 8, It is a bug.

[JasonLuo-Redgate]

Hi @eliufen2020 ,

Sorry for the confusion. The provided log shows that, in your case, the engine edition returned to Flyway from the server is 10.