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?
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