documentation/Reference/Commands/Snapshot.md
{% include enterprise.html %}
Generates a snapshot from a database environment, build environment, schema snapshot folder or empty source. A snapshot captures the schema of a specified source into a file for subsequent use with the Check Changes command, Check Drift command, Snapshot command or [Snapshot provisioner](Configuration/Environments Namespace/Environment Provisioner Setting/Snapshot Provisioner).
Be sure to set environment schemas when generating a snapshot for Oracle databases.
Snapshots may be stored in the snapshot history table by specifying an appropriate location using the
filename parameter. In
this case, Flyway will create the snapshot history table automatically if it doesn't exist.
See Snapshots for more information.
flyway snapshot -url=jdbc:sqlserver://localhost:1433;encrypt=false;databaseName=Inventory -user=sa -password=... -filename=C:\snapshot.json
if a database environment named dev is configured in the flyway.toml file, then the environment name can be provided
as a CLI argument instead of passing the connection details as CLI arguments.
flyway snapshot -source=dev -filename=C:\snapshot.json
flyway snapshot -source=schemaSnapshot -filename=C:\snapshot.json
flyway snapshot -source=migrations -buildEnvironment=shadow -buildVersion=2 -filename=C:\snapshot.json
The snapshot.build* arguments make it possible to create a snapshot for any migration version.
| Parameter | Namespace | Description |
|---|---|---|
filename | snapshot | Destination location for the snapshot. Can be a file path, or a snapshot history table entry. |
| Parameter | Namespace | Description |
|---|---|---|
source | snapshot | The source from which a snapshot should be generated. |
historyTable | snapshot | The name of the Flyway snapshot history database table, in which to store snapshots. |
historyLimit | snapshot | The maximum number of snapshots to store in the database table. |
buildEnvironment | snapshot | If source is migrations, this specifies the environment to use as the build environment. |
buildVersion | snapshot | If source is migrations, this specifies migration version to migrate the build environment to. |
buildCherryPick | snapshot | If source is migrations, this specifies list of migrations to migrate the build environment with. |
rebuild | snapshot | If source is migrations, forces a reprovision (rebuild) of the build environment. |
schemaModelLocation | (root) | The path to the schema model. |
schemaModelSchemas | (root) | The schemas in the schema model. |
workingDirectory | (root) | The directory to consider the current working directory. All relative paths will be considered relative to this. |
| {environment parameters} | (root) | Environment configuration for the source environment. |
Universal commandline parameters are listed here.
Settings from the following sections of the Flyway namespace can be specified in relation to database connections:
When the source is migrations, settings from the following sections of
the Flyway namespace can also be set:
{
"filename": "C:\snapshot.json"
}
This command can produce the following error codes:
When storing snapshots to the Flyway Snapshot History Table, there is a size constraint. The snapshots will be compressed before insertion into the table, so the constraint only applies after compression.
| Database | Datatype | Size |
|---|---|---|
| SQL Server | VARBINARY(MAX) | 2Gb |
| Oracle | BLOB | 4Gb |
| MySQL | LONGBLOB | 2Gb |
| PostgreSQL | BYTEA | 1Gb |