flyway == Flyway is used to do migrations in db , It reads the sql files from spring boot app and run the queries in the database.
- For migration store sql files in db.migration folder.
- By default flyway creates a table to track the files that has been executed.
- we can changes the database to connect for flyway by default it creates in main db.
- Every sql file is transactional in flyway, if problems occurs in any place in sql file, it will rollback the previous content of same file.
- Naming of sql file for flyway = V<squence_number>__.sql
- We can configure these naming rules in properties file.
- In flyway it is possible to do migration from java code also for that we need to extends class with BaseJavaMigration class and write our queries in migrate method