Step by Step: How to Migrate your DB Schemas with Flyway
How do you take your database schema and your data to the next release? Do you herd a collection of delta scripts? Do you know exactly which version of which object was deployed in your different environments at a certain point in time?
Find out how the open-source tool Flyway can help you manage your database schema changes in an agile environment and how easy it is to get started.
After several years of using Flyway Community Edition in combination with an Oracle database I would like to share my insights about
– How to write scripts for Oracle database in Java, DDL and PL/SQL
– How to organise your scripts
– Potential pitfalls and workarounds
– A short comparison with alternative tools
Flyway integrates with various build frameworks like Ant, Maven or Gradle but for demo purposes we will stick with the command line.
This session will give you the basic knowledge and a collection of sample scripts to start right away.