Apache Maven vs. Redgate Flyway

Building and automating packaging of software can be a challenging task. As the complexity of the project grows so do the dependencies on third-party artifacts. Using Maven we can define and manage the project structure centrally and it helps improve overall build times.

Incentivized

If your application is running on many environments then some kind of automation for database migrations should be implemented. This will save time and trouble for employees and helps to manage migrations. However it must be understood that it is not a magical tool & should be studied properly so that it's limitations are understood & it will be used properly. Otherwise it might cause problems to the application.

Incentivized

• Makes the build process simple and easy to do.
• It provides a standard build system that can be adopted by multiple, different groups within an organization.
• It's extensible with easy to use custom extensions which our developers take full advantage of.

Incentivized

• Keeps track of migrations
• Makes it really easy to version and review queries
• Helps you understand what you have deployed, where super easily

Incentivized

• One of the issues with building software using Apache Maven is that its cache resolution is not optimal. It pulls down all the artifacts onto the developer's local machine and can sometimes result in conflicts.
• The build process can vary in time and gets progressively longer as the project's complexity increases.

Incentivized

• For the script, especially for inserting a new row of data, I'd like to see to use if not exists, then insert, else just update.
• When we run the script, it will error out if we use not exists for inserting new table rows.

The overall usability of Apache Maven is very good to us. We were able to incorporate it into our company's build process pretty quickly. We deployed it to multiple teams throughout the entire enterprise. We got good feedback from our developers stating that Apache Maven has simplified their build process. It also allowed to to standardize the build process for the entire enterprise, thus ensure that each development team is using the same, consistent process to build code.

Incentivized

It's very easy to install and use. Even someone very new to the software will have no trouble, plus the team reach out to help you and continue to offer you support throughout. Really simple interface, clean design, all you could really ask for in a tool that needs to do a job dependably

Incentivized

I can't speak to the support, as I've never had issues. Apache Maven "just works," and errors were user errors or local nexus errors. Apache Maven is a great build/dependency management tool. I give it a 9/10 because occasionally the error message don't immediately indicate a solution...but again, those errors were always user or configuration errors, and the Maven documentation is extensive, so I don't find fault in Maven, but in its users.

Incentivized

Ant is useful if your build is heavily based on customs scripts running in the right order. Maven greatly simplifies the process to keep track of and download build dependencies compared with Apache Ant. If your build is based on multiple custom scripts running in a specific order there is a lot of overhead in Maven compared to Apache Ant.

Incentivized

The problem with a cloud-based tool for migration services is the cloud dependency. You are restricted to use the tool along the Cloud provider. Flyway gives you the freedom to use it in any scenario as long as you are working with a compatible database engine. Even if you are working on-premise and you don't have plans to move to a cloud architecture. Or even for sandbox development scenarios where you are a developer playing around with some project ideas. And you don't have to pay anything as long as you need advanced features, and not less importantly, you are using an open-source tool.

Incentivized

• Maven has been the only tool for building Java apps for a long time. And it being open source has helped maximize ROI.
• I can't think of any negative. With Gradle coming up as a newer and better technology for building, some teams are shifting towards it.

Incentivized

• DB migration is fully automated
• DB migration is committed to source code, repeatable on all environments
• DB migration is fully integrated into development cycle

Incentivized