1

I am looking for a tool that will manage the versioning of Azure SQL Databases, and check for missing schema or migration scripts and apply those changes based on what is missing.

Any other solutions or tips would be great. I just want to make sure the database schema is flat across the board regardless, and apply changes based on version number.

Any suggestions?

2 Answers 2

1

I assume from the ansible tag in your question that you need something that can run from a command line, so that rules out plugins to SSMS like dbForge.

Try Flyway (has a free version) or Red Gate (commercial).

0

Did you try DbUp? DbUp homepage This utility can apply patches to database and maintain its version.

It writes execution log to databases and is able to run scripts that were not applied.

I'm using that project over 3 years now and it does it job well.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.