CODEWITHSUNDEEP
sqldatabasediffliquibase
enorniel
enorniel

Reputation: 31

Compare data between databases with difftype=data liquibase

I try to integrate a versioning system for my databases. I use liquibase.

I work with the diff system because I modify the sql directly and I don't want to have to report the changes I made manually.

It works for schemas but not really for datas. I tried to use the difftype=data on generatechangelog but I don't know how to do to compare 2 databases datas.

Do you have any solution ?

Upvotes: 2

Views: 3197

Answers (1)

Nathan Voxland
Nathan Voxland

Reputation: 15763

If you are comparing databses you want to use diffChangeLog rather than generateChangeLog. GenerateChangeLog outputs the full creation logic for a single database, it doesn't compare two databases.

GenerateChangeLog supports the diffType=data attribute which will output the contents of a database as csv or insert statements, but there is no support for comparing data in two databases.

Upvotes: 4

Related Questions