uid | title |
---|---|
dotnet-fm |
dotnet-fm tool |
dotnet tool install -g FluentMigrator.DotNet.Cli
You can run the tool with dotnet fm
or dotnet-fm
. Use the latter version if the former doesn't work due to a .NET Core CLI tool bug.
dotnet-fm -+- list -+- migrations = List applied and pending migrations
| +- processors = List all available processors
+- migrate = Apply all migrations
| +- up = Apply migrations up to given version (inclusive)
| +- down = Apply migrations down to given version (exclusive)
+- rollback = Rollback the last migration applied
| +- all = Rollback all migrations
| +- by = Rollback by <n> steps
| +- to = Rollback to given version
+- validate --- versions = Validate order of applied migrations
Shows all available processor identifiers to be used by the -p
or --processor
command line switch.
Overrides the default .NET Assembly Loading logic, allowing you to load assemblies written for other versions of the .NET runtime. This is primarily intended for developers working on preview releases of the next version of the .NET runtime, but can be used by others as a workaround for assembly not found errors. In particular, it is possible to have a "diamond dependency" where some dependencies have higher assembly versions than the one FluentMigrator uses.
For example, suppose FluentMigrator.DotNet.Cli ships with a particular version of System.ComponentModel.DataAnnotations. Further suppose that you have a private enterprise nuget package repository that has re-usable FluentMigrator extension methods, which transitively references a different verison of System.ComponentModel.DataAnnotations. There are only two possible ways you can call such an extension method: (1) implement your own FluentMigrator.DotNet.Cli tool and directly package your migrations DLL with the tool so that the MSBuild Microsoft.NET.Sdk correctly builds a project.deps.json used to resolve the right assembly (2) use this --allowDirtyAssemblies
switch.
As another example, suppose FluentMigrator has not yet shipped a .NET vNext compatible binary, but you want to work with that binary. The --allowDirtyAssemblies
switch will help resolve the System.Runtime
assembly.
The following commands need a processor id and/or a connection:
- dotnet-fm list migrations
- dotnet-fm migrate
- dotnet-fm rollback
- dotnet-fm validate
The connection string itself to the server and database you want to execute your migrations against.
Indicates that migrations will be generated without consulting a target database. Should only be used when generating an output file.
The kind of database you are migrating against. Available choices can be shown with list processors.
Database processor specific switches, e.g.:
- Firebird:
Force Quote=true
- Oracle:
QUOTEDIDENTIFIERS=TRUE
Only output the migration steps - do not execute them. Add the --verbose
switch to also see the SQL statements.
Default is false.
Show the SQL statements generated and execution time in the console. Default is false.
The profile to run after executing migrations.
Set ApplicationContext to the given string.
Overrides the default database command timeout of 30 seconds.
Output generated SQL to a file. Default is no output. A filename may be specified, otherwise [targetAssemblyName].sql is the default.
The assemblies containing the migrations you want to execute.
The namespace contains the migrations you want to run. Default is all migrations found within the Target Assembly will be run.
Whether migrations in nested namespaces should be included. Used in conjunction with the namespace option.
The specific version to start migrating from. Only used when NoConnection is true. Default is 0.
The directory to load SQL scripts specified by migrations from.
Filters the migrations to be run by tag.
Allows execution of migrations marked as breaking changes.
Overrides the transaction behavior of migrations, so that all migrations to be executed will run in one transaction. Allowed values are:
- Migration
- Session
Reverts all migrations.
Reverts the last <steps>
migrations.
Reverts all migrations down to (and excluding) <version>
.
Applies the found migrations.
The specific version to migrate to (inclusive).
Applies the found migrations.
The specific version to revert to (exclusive).
Whether comments should be stripped from SQL text prior to executing migration on server. Default is true; false will become the default in 4.x.
dotnet fm list processors
dotnet fm list migrations -p sqlite -c "Data Source=test.db" -a FluentMigrator.Example.Migrations.dll
dotnet fm migrate -p sqlite -c "Data Source=test.db" -a FluentMigrator.Example.Migrations.dll
dotnet fm migrate -p sqlite -c "Data Source=test.db" -a FluentMigrator.Example.Migrations.dll up -t 20090906205342
dotnet fm migrate -p sqlite -c "Data Source=test.db" -a FluentMigrator.Example.Migrations.dll down -t 20090906205342
dotnet fm rollback -p sqlite -c "Data Source=test.db" -a FluentMigrator.Example.Migrations.dll
dotnet fm rollback -p sqlite -c "Data Source=test.db" -a FluentMigrator.Example.Migrations.dll to 20090906205342
dotnet fm rollback -p sqlite -c "Data Source=test.db" -a FluentMigrator.Example.Migrations.dll by 1
dotnet fm rollback -p sqlite -c "Data Source=test.db" -a FluentMigrator.Example.Migrations.dll all
dotnet fm validate versions -p sqlite -c "Data Source=test.db" -a FluentMigrator.Example.Migrations.dll