Diff and Snapshot Comparison

Use the Pro diff workflow to investigate differences between applied migrations and the live database schema. Portable snapshot export belongs to Enterprise.

Use the Pro diff workflow to investigate differences between applied migrations and the live database schema. Portable snapshot export belongs to Enterprise.

What DBLift can compare

DBLift can compare the schema represented by applied migrations with live database state via the internal snapshot table. There is no separate drift command; the user-facing command is diff. A portable snapshot file is not an input to diff.

Plan and preflight do not perform live schema comparison — run diff separately when you need comparison evidence.

Running a comparison

dblift diff
dblift diff --ignore-unmanaged
dblift diff --generate-sql --output-file review.sql

Options

OptionDescription
--ignore-unmanagedIgnore objects not managed by DBLift migrations
--generate-sqlEmit synchronization SQL for review
--output-fileWrite generated SQL to a file

See the Commands reference for the full option list.

DBLift is information technology / developer tools software. Contact: contact@dblift.com.