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.
Okay, let’s try cleaning it - a destructive process potentially, but the risks were low in my case. So, did a
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.