I’m currently evaluating liquibase for use with an existing enterprise project. The existing production (and pre-production) database is managed by another party and one of their requirements is that at the hand over point we give them all the DML and DDL changes in pure SQL. We therefore have to at some point convert any deltas for the latest release into SQL files. Is there some way of doing this with liquibase, or some strategy that could be used e.g. always referencing an externalised SQL file within a given changeset? Any pointers or suggestions are appreciated.
I would start here by looking at the “Don’t execute changesets, save SQL to /tmp/script.sql” section of this page:
That’s at least one way to deliver pure SQL for a changeset.