Lucky to find a Flyway alternative that has all the features I require at a much lower price. Rumba supports popular plain-SQL migration scripts, versioning, and database schema changes tracking at full scale.
Migrations of database schemas are an unavoidable part of any database-driven software project. You may need to update your database structure as your project grows to accommodate new features or address faults. When it comes to designing and delivering applications, schema migrations are critical. You can ensure that your database is always consistent and compatible with the current source code by using the right tool.
I’m not interested in any of the particular database engines, programming languages, or framework support. I already have my preferred database and have discovered that such a tool cannot rely on project code in any way. Framework integration, such as the ability to change database schema at application startup, will train programmers to do terrible things.
Declarative schema definition would be a great addition to such a database management tool. It would allow to easily and faster define the data structure in some way. This would be especially beneficial for prototyping when the database scheme is rapidly changed.
The helper tool must provide a way to quickly generate SQL scripts for database changes. It would be nice if it could also help format the resulting script for readability, but that is not a requirement. Being able to quickly generate the script without having to worry about the syntax is key. The next feature I would want is the ability to compare two versions of a database.
Less price, lower the risks
When beginning a project, keep in mind that there will always be risks and costs. While it is critical to consider the risks and costs of a project, it is also critical to be realistic about the potential return on investment. In some circumstances, the investment may be too large in comparison to the prospective return. In these instances, it may be wise to look for another project to invest in.
This type of software may be fairly expensive; the licensing fee of the most marketed products starts at three thousand dollars in yearly subscription, which will delay my prospective investment return.
A perfect tool should be self-contained and free of third-party dependencies. This is significant because it guarantees that the tool will always be available and reliable, regardless of the setting or context in which it is utilized. It also removes the need to locate and install any other software or libraries, which can be a time-consuming and tedious procedure.
Flyway drawbacks
Flyway requires Java installed and offers features I’ll never ever use. Some of its features are doubtful, some other features are not compatible with my development. I also don’t need any exotic database support. I always stay with PostgreSQL.

