Does LiquiBase generate DDL for schema diff?

Question

Is there a way to generate DDL for schema differences, much like the Synch capability in TOAD?

Not certain how the "updateSQL" option is used? I am using the diff option for comparing schemas.

Answer 1

You can do it with two steps:

1. Running diffChangeLog between two schemas will output a Liquibase changelog file describing what it will take to update one schema to match the other
2. If you run updateSQL passing the generated changeLog, Liquibase will output the SQL it will execute when running the changelog