CODEWITHSUNDEEP
javadatabaseliquibasedata-comparison
Amir Maleki
Amir Maleki

Reputation: 419

Compare two Data Base DATA with liquibase

I want to find a way to compare DATA with liquibase. I tried this liquibase.peroperties file:

driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
classpath:mssql-jdbc-7.0.0.jre8.jar
url: jdbc:sqlserver://localhost:1433;databaseName=Master_DB
username:sa
password:Password1
changeLogFile:db.changelog.xml
referenceUrl: jdbc:sqlserver://localhost:1433;databaseName=test_db
referenceUsername:sa
referencePassword:Password1
diffTypes:tables, columns, views, primaryKeys, indexes, foreignKeys, sequences, data

and I ran the liquibase with this command

liquibase diff

It shows me all the differences but not the exact differences in data. The result said that

Missing Data(s):NONE
Unexpected Data(s): NONE

But I know there are several differences in the data. Any suggestion?

Upvotes: 0

Views: 296

Answers (0)

Related Questions