Redgate Flyway

Model

Description

Flyway Enterprise

The model command allows differences found by running the diff command to be applied to the schema model. The schema model must be one of the comparison sources used in the diff artifact provided to model.

See Schema Model for more information.

Usage examples

Saving changes from a database to the schema model

The diff command must first be run to discover the changes (see diff.artifactFilename) that can be saved to the schema model. The diff command can be combined with model into a single flyway call with verb chaining.

For example, the following command generates a diff between a database environment called dev and the schema model, saving the changes back into the schema model:

> flyway diff model -diff.source=dev -diff.target=schemaModel

Parameters

Optional

Parameter Namespace Description
artifactFilename model The path to the diff artifact.
changes model A comma separated list of change ids.

Universal commandline parameters are listed here.

JSON output format

{
  "messages" : [ ],
  "includedDependencies" : [ ],
  "filesChanged" : [ "C:\\Users\\Project\\schema-model\\MySchema\\Tables\\country.rgm" ]
}

Error codes

This command can produce the following error codes:


Didn't find what you were looking for?