Database snapshots
What is a Snapshot
A snapshot is an XML representation of the database schema that can be stored with version control or copied elsewhere as a schema backup.
SQL Delta and SQL DXP can use a snapshot in a schema compare to compare an offline schema with an online schema.
Snapshot Compare
A snapshot can be used as the source of a schema compare, providing a way to restore from a backup or compare changes between saved schema states.
Offline and remote review
This makes it possible to compare a remote database schema by using a snapshot, generate an update script and then apply that script later against the remote target.