[
https://issues.apache.org/jira/browse/FINERACT-2704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=18106386#comment-18106386
]
Sonigra Bhavya Hemendrabhai commented on FINERACT-2704:
-------------------------------------------------------
Hi [~meonkeys], I’ve successfully completed the database re-baseline for 1.15.0
and opened a PR for this!
To summarize the approach taken:
Generated a consolidated 0001_initial_schema.sql (DDL) and
0002_initial_data.sql (DML).
Cleaned up the data dump by converting all COPY ... FROM STDIN blocks to
standard INSERT INTO statements for Liquibase JDBC compatibility.
Added setval() statements at the end of the data dump to properly reset all
auto-incrementing sequences (including Spring Batch sequences) to prevent
primary key collisions.
Purged all pre-1.15.0 migrations and renumbered the remaining post-1.15.0
migrations sequentially starting from 0003.
Testing on a fresh database (./gradlew devRun) was extremely fast (approx. ~45
seconds startup time) and all 1,350 unit tests are passing cleanly.
Let me know if you have any feedback on the PR!
> re-baseline database migrations
> -------------------------------
>
> Key: FINERACT-2704
> URL: https://issues.apache.org/jira/browse/FINERACT-2704
> Project: Apache Fineract
> Issue Type: Improvement
> Components: Build
> Reporter: Adam Monsen
> Priority: Minor
> Labels: beginner
> Attachments: Screenshot 2026-08-20 at 11.18.23 PM.png
>
>
> {{./gradlew devRun}} is pretty slow for a fresh database. Part of the reason
> is that many liquibase database migrations need to run.
> Re-baseline our db migrations as of the current release (1.15.0): create an
> empty database, run all migrations, then re-create initial schema and initial
> data files. Leave any schema/data migrations created post-1.15.0 in place,
> but you may re-number all initial and migration files starting at 0001.
> We'll plan on doing this once per release, back to the last supported/stable
> release.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
