Diff between DB and changelog?

Somebody changed the database with external tools.
Is it possible to create a diff between a changelog-file and the database?
I hoped it is possible to see the changes somebody made to the DB and create the change file afterwards.
Is this possible?

I would be interested in the same functionality.
As a workaround you could setup another schema like ‘orig_scheme_temp’ with the changelog and then diff this one against the modified database with something like:

liquibase.bat --classpath=“C:\Programme\MySQL\mysql-connector-java-5.1.18.jar” --driver=com.mysql.jdbc.Driver --url=jdbc:mysql://localhost:3306/modified_schema --username=usr --password=TopSecret --referenceUrl=jdbc:mysql://localhost:3306/orig_scheme_temp --referenceUsername=usr–referencePassword=TopSecret diffChangeLog > diff.xml

Greetings

  PowerStat

It is a commonly requested feature, but is not currently supported. There are a few difficult issues to resolve, mainly any blocks would require a database-independent SQL parser and engine. 


For now, I generally recommend the “run the changelog against a blank database and comare those” approach too.


Nathan