What is the Flyway migration tool?

Question

Accepted Answer

**Flyway** — database migration tool for version control of SQL schemas.

```java
// application.yml
spring:
  flyway:
    enabled: true
    locations: classpath:db/migration
    baseline-on-migrate: true
```

```sql
-- V1__create_users_table.sql
CREATE TABLE users (
    id BIGINT PRIMARY KEY AUTO_INCREMENT,
    name VARCHAR(255) NOT NULL,
    email VARCHAR(255) UNIQUE NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

-- V2__add_user_status.sql
ALTER TABLE users ADD COLUMN status VARCHAR(20) DEFAULT 'ACTIVE';
```

**Key features:**
- Naming convention: V{version}__{description}.sql.
- Tracks applied migrations in flyway_schema_history.
- Automatic migration on startup.
- Supports SQL, Java, and Kotlin migrations.

Java: What is the Flyway migration tool?