Resolve problem #24, and introduce framework conversion data changes
authorKarl O. Pinc kop@karlpinc.com <kop@karlpinc.com>
Tue, 5 May 2026 16:06:38 +0000 (16:06 +0000)
committerKarl O. Pinc kop@karlpinc.com <kop@karlpinc.com>
Tue, 5 May 2026 16:06:38 +0000 (16:06 +0000)
commite29b2ef21b2278fcd3aaa055268a4cdc9e361ab0
tree2933cda91e02971fe4a4ac6b8ebca437f0cc79c4
parentdb092c876665d0ecc92859aa26be891c3f4d1053
Resolve problem #24, and introduce framework conversion data changes

This introduces the conv_state schema, where state is saved
that records "automatic" changes the conversion makes to the
converted data.  When the MS Access data is changed and
the conversion re-run, the "new" automatic changes can be compared
to the changes made to the previous data set.

The "compare-state" make target can be used to report differences
between the old and new data.  Review this report to ensure
that the automated "fixes" do not change something that should
not be changed.
conversion/Makefile
conversion/clean.sql
conversion/compare_state.sh [new file with mode: 0644]
conversion/compare_state.sql [new file with mode: 0644]
conversion/copy_state.sql [new file with mode: 0644]
conversion/createschemas.sql