| Locations |
Yes/No * |
Sql_Scripts |
Paths (separated by semicolon) to scan recursively for migrations. *Mandatory if EmbeddedResourceAssemblies is empty. |
| Schemas |
No |
|
A semicolon separated list of schema managed by Evolve. If empty, the default schema for the datasource connection is used. |
| Command |
No |
|
- migrate: applies the migrations
- erase: erases the database schema(s) if Evolve has created it or has found it empty
- repair: corrects checksums of already applied migrations, with the ones from actual migration scripts
- info: displays the details and status information about all the migrations
|
| TransactionModeNew |
No |
CommitEach |
- CommitEach: Commit each successful script and rollback only the one that fails
- CommitAll: Commit a group of scripts at once and rollback them all if one fails. Either all succedeed or nothing is applied.
- RollbackAll: Execute the scripts of the migration and then rollback them all, in order to preview/validate the changes Evolve would make to the database.
|
| EraseDisabled |
No |
|
When true, ensures that Evolve will never erase schemas. Highly recommended in production. |
| EraseOnValidationError |
No |
|
When true, if validation phase fails, Evolve will erase the database schemas and will re-execute migration scripts from scratch. Intended to be used in development only. |
| StartVersion |
No |
0 |
Version used as starting point for already existing databases. If empty, start version = 0. |
| TargetVersion |
No |
|
Target version to reach. If empty it evolves all the way up. |
| OutOfOrder |
No |
false |
Allows migrations to be run “out of order”. If you already have versions 1 and 3 applied, and now a version 2 is found, it will be applied too instead of being ignored. |
| SkipNextMigrationsNew |
No |
false |
Mark all subsequent migrations as already applied. |
| RetryRepeatableMigrationsUntilNoErrorNew |
No |
false |
Execute repeatedly all repeatable migrations for as long as the number of errors decreases. Allows repeatable migrations to be executed in any order regarding their dependencies, so that you can named them more easily. |
| EmbeddedResourceAssemblies |
Yes/No * |
|
Assemblies (separated by semicolon) to scan in order to load embedded migration scripts. *Mandatory if Locations is empty. |
| EmbeddedResourceFilters |
No |
|
Includes embedded migration scripts that start with one of these filters (separated by semicolon). |
| CommandTimeout |
No |
|
The time in seconds to wait for the migration to execute before terminating the command and generating an error. |
| Encoding |
No |
UTF-8 |
The encoding of SQL migration files. |
| SqlMigrationPrefix |
No |
V |
Migration file name prefix. |
| SqlRepeatableMigrationPrefix |
No |
R |
Repeatable migration file name prefix. |
| SqlMigrationSeparator |
No |
__ |
Migration file name separator. |
| SqlMigrationSuffix |
No |
.sql |
Migration file name suffix. |
| MetadataTableSchema |
No |
|
The schema containing the metadata table. If empty, the first schema defined in Schemas or the one of the datasource connection. |
| MetadataTableName |
No |
changelog |
The metadata table name. |
| PlaceholderPrefix |
No |
${ |
The prefix of the placeholders. |
| PlaceholderSuffix |
No |
} |
The suffix of the placeholders. |
| Placeholders |
No |
|
Placeholders are strings to replace in sql migrations at runtime. |
| EnableClusterMode |
No |
true |
When true, Evolve will use a session level lock to coordinate the migrations on multiple nodes. This prevents two distinct Evolve executions from executing an Evolve command on the same database at the same time. |