5 ms·
How does liquibase compare to flyway?
by gdsdfe 6y ago
How does liquibase compare to flyway?
- rickette 6y agoThe main difference: in Liquibase you write migrations using XML and in Flyway you write migrations in SQL. At least that was the original differentiator, things might have changed in the last couple of years. I've always preferred Flyway since SQL is the natural language to interact with your RDBMS. I would only consider writing migrations in XML if I have to support multiple database implementations e.g. when you built a product like Jira or SonarQube that support different databases (but think twice wether you want to go down that rabbit hole).
- devone2 6y agoYou can write migration in sql using liquibase as well. Just use tag <sql> and you can write your favorite dialect. Also you can set sql dialect on migration so you can support multiple db engines. https://docs.liquibase.com/change-types/community/sql.html https://docs.liquibase.com/change-types/community/sql.html
- cmiles74 6y agoI think the issue here is that the <sql> tag is embedded in a larger XML document. IMHO, XML is no fun to work with by hand.