search

link-intersystems / dbunit-extensions

Extensions for the dbunit testing library.
Apache License 2.0
0 stars 0 forks source link

lis-dbunit-migration should only export the database diff between two versions #1

Closed renelink closed 2 years ago

renelink commented 2 years ago

Since flyway scripts are pure SQL they can insert data into the database. The migrated dataset should not contain the data that was inserted by flyway scripts. Thus lis-dbunit-migration needs to make a diff between the source and target db version.

The process should be:

  1. Setup a clean database
  2. Let flyway migrate to a source version
  3. Save the database state of the source version
  4. Insert the dataset that should be migrated
  5. Migrate the dataset using flyway to the target version.
  6. Export the target version as dataset
  7. Make a diff between the target and source version
  8. Export the changed dataset (the diff).
renelink commented 2 years ago

Released as version 1.8.0