Can't get data diff to work


I’m trying to get a diff of the data of two databases but I can’t get it to work. I always get the structural differences. Here is the command I’m using:

    call liquibase.bat ^   --driver=oracle.jdbc.OracleDriver ^   --classpath=ojdbc5.jar ^   --url=jdbc:oracle:thin:@myserver:1521:orcl ^   --username=first_user ^   --password=my_password ^   diffChangeLog ^   --diffTypes=data ^   --baseUrl=jdbc:oracle:thin:@myserver:1521:orcl ^   --baseUsername=second_user ^   --basePassword=second_password
(Windows batch file)

What am I missing here?

It is because the data diff (and controlling what to diff) is only available when you are doing a generateChangeLog, not a standard diff.

I don’t think we will ever support data diffing between databases well because there gets to be too much and there are semantic questions of what data is actually different and which are actually the same that is too hard to solve in general.