Model
Published 15 January 2025
Description
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: