I have a Play framework powered application with database as a persistance layer (and I use Slick for that). I have enabled evolutions, generated 1.sql
file and successfully rolled it out to production.
Client requests new features that require database schema modifications - ie. adding new tables, adding new columns and changes to existing columns' nullability.
Once all Slick's Table definitions and related code are updated, I generate schema once again and place it as 2.sql
. Evolutions are correctly requested to be run but... generated evolutions does not reflect an incremental update on top of 1.sql state but rather instructions how to create database schema from scratch (ie. CREATE TABLE with all the columns, including new ones rather than ADD COLUMN casuses).
Is it possible to achieve an incremental update so that I can easily just run it in production to get database from revision #1 to revision #2 (SQL "diff" between #1 and #2) or do I have to manually create those evolutions?