flyway, SQL server and non-empty schema?

ยท Updated:

While attempting to use flyway for SQL server schema migrations, I was consistently getting an error of the form Found non-empty schema xxx ithout metadata table! Use init() or set initOnMigrate to true to initialize the metadata table.. Okay, so easy - let me just delete the tables, drop the schema and we will be good. No luck!

Okay, let’s try cleaning it - a destructive process potentially, but the risks were low in my case. So, did a flyway clean and what do I see? There were some SQL server assemblies. Apparently they are “global” in nature.

Removing those unused assemblies fixed the issue with flyway migration.

Dive deeper with Tiny LLM (optional)

Open Tiny LLM Lab with this post preloaded