Home ¦ Posts ¦ Books ¦ Articles ¦ Talks ¦ Notes

flyway, SQL server and non-empty schema?

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.

Share on: Diaspora*TwitterFacebookGoogle+Email

© Amit Saha. Built using Pelican. Customised theme based on the one by Giulio Fidente on github.