Bulk insert - Multiple changesets or one changeset?

Community Answers
1

I know the general rule of liquibase is one change per changeset, does this apply to bulk inserts?

We have some setup data in one table that should ideally be grouped together. It should all be inserted(or rolled back) together. Should it be in one changeset? What is the best practice for Bulk inserts?

2

The recommendation of “one change per changeset” is really just for DDL, not DML. What you have described can be in one changeset.

1 Like
3

Thanks. I figured. There was another example I saw somewhere on your site that had multiple inserts in one changeset.