NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →
NuGet
NuGet, #1133 most downloaded on NuGet
FluentMigrator is a database migration framework for .NET written in C#. The basic idea is that you can create migrations which are simply classes that derive from the Migration base class and have a Migration attribute with a unique version number attached to them. Upon executing FluentMigrator, you tell it which version to migrate to and it will run all necessary migrations in order to bring your database up to that version. In addition to forward migration support, FluentMigrator also supports different ways to execute the migrations along with selective migrations called profiles and executing arbitrary SQL.
Latest stable
8.0.1
Last release 10 months ago
21 Jan 2026
Ships unpredictably
gaps range from 8 days to 1.9 years
Nearly every release is documented
notes for 41 of 41 stable releases
2 versions withdrawn
withdrawn after publishing
127 years old
43 releases · first in 1900
Drag across the ruler to compare, or tap a release to open it.
Latest changes and detailed release notes are available on GitHub Releases: https://github.com/fluentmigrator/fluentmigrator/releases
Latest changes and detailed release notes are available on GitHub Releases: https://github.com/fluentmigrator/fluentmigrator/releases
Full Changelog: v8.0.0...v8.0.1
Milestone log: https://github.com/fluentmigrator/fluentmigrator/milestone/62
Your coding agent can read these notes before it upgrades. Set up the MCP server →
Full Changelog: https://github.com/fluentmigrator/fluentmigrator/compare/v8.0.0...v8.0.1
Milestone log: https://github.com/fluentmigrator/fluentmigrator/milestone/62
Latest changes and detailed release notes are available on GitHub Releases: https://github.com/fluentmigrator/fluentmigrator/releases
Latest changes and detailed release notes are available on GitHub Releases: https://github.com/fluentmigrator/fluentmigrator/releases
Full Changelog: v7.2.0...v8.0.0
Milestone log: https://github.com/fluentmigrator/fluentmigrator/milestone/61
Full Changelog: https://github.com/fluentmigrator/fluentmigrator/compare/v7.2.0...v8.0.0
Milestone log: https://github.com/fluentmigrator/fluentmigrator/milestone/61
Use of standard dependency injection, configuration and logging libraries. Simplification of in-process runner configuration and instantiation. Minimu
Use of standard dependency injection, configuration and logging libraries. Simplification of in-process runner configuration and instantiation. Minimum .NET Framework version is 4.8, see https://aka.ms/msbuild/developerpacks for more information.
Details: https://github.com/fluentmigrator/fluentmigrator/releases
Remove obsolete IMigrationProcessor.ConnectionString (fixes #2036) by @PhenX in #2120
Remove obsolete constructor in DotConnectOracleDbFactory by @jzabroski in #2133
Remove obsolete constructors on DefaultVersionTableMetaData by @jzabroski in #2134
Remove obsolete ReflectionBasedDbFactory constructors by @jzabroski in #2138
Add comprehensive VitePress documentation website for FluentMigrator by @PhenX in #2166
Fix VitePress base path for organization GitHub Pages deployment by @Copilot in #2177
Add conditional net48 targeting to FluentMigrator.Analyzers.Tests by @Copilot in #2184
Configure FluentMigrator-specific Copilot instructions by @Copilot in #2180
Deploy docs to fluentmigrator/fluentmigrator.github.io repository by @Copilot in #2185
Full Changelog: v7.1.0...v7.2.0
Remove obsolete IMigrationProcessor.ConnectionString (fixes #2036) by @PhenX in https://github.com/fluentmigrator/fluentmigrator/pull/2120
Remove obsolete constructor in DotConnectOracleDbFactory by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/2133
Remove obsolete constructors on DefaultVersionTableMetaData by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/2134
Remove obsolete ReflectionBasedDbFactory constructors by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/2138
Add comprehensive VitePress documentation website for FluentMigrator by @PhenX in https://github.com/fluentmigrator/fluentmigrator/pull/2166
Fix VitePress base path for organization GitHub Pages deployment by @Copilot in https://github.com/fluentmigrator/fluentmigrator/pull/2177
Add conditional net48 targeting to FluentMigrator.Analyzers.Tests by @Copilot in https://github.com/fluentmigrator/fluentmigrator/pull/2184
Configure FluentMigrator-specific Copilot instructions by @Copilot in https://github.com/fluentmigrator/fluentmigrator/pull/2180
Deploy docs to fluentmigrator/fluentmigrator.github.io repository by @Copilot in https://github.com/fluentmigrator/fluentmigrator/pull/2185
Full Changelog: https://github.com/fluentmigrator/fluentmigrator/compare/v7.1.0...v7.2.0
Use of standard dependency injection, configuration and logging libraries. Simplification of in-process runner configuration and instantiation. Minimu
Use of standard dependency injection, configuration and logging libraries. Simplification of in-process runner configuration and instantiation. Minimum .NET Framework version is 4.8, see https://aka.ms/msbuild/developerpacks for more information.
Details: https://github.com/fluentmigrator/fluentmigrator/releases
As part of fixing #2018, IMigrationGenerator now has explicit GeneratorId and GeneratorIdAliases properties.
ProcessorId constants class is now named ProcessorIdConstants. There is now a parallel GeneratorIdConstants class. Generally, these will be 1:1, but there may be useful scenarios to decouple the two.
As part of fixing #2018, AddPostgres no longer registers PostgresProcessor and PostgresGenerator (the base interfaces). It will now always register the "latest" database version. Currently, Postgres15_0Processor and Postgres15_0Generator. Generally, this should have minimal impact to end users as the main impact would be if you were on a 14 year old version of Postgres.
Full Changelog: v7.0.0...v7.1.0
Use of standard dependency injection, configuration and logging libraries. Simplification of in-process runner configuration and instantiation. Minimu
Use of standard dependency injection, configuration and logging libraries. Simplification of in-process runner configuration and instantiation. Minimum .NET Framework version is 4.8, see https://aka.ms/msbuild/developerpacks for more information.
Details: https://github.com/fluentmigrator/fluentmigrator/releases
AppliedOn by @nathanpovo in #1847
MicrosoftBuildLogger. by @teo-tsirpanis in #1905The main area we could use help right now is with fluentmigrator/documentation repository and automating the documentation release process further. Additionally, fixing build related warnings for missing MSDoc comments would be extremely appreciated.
Full Changelog: v6.2.0...v7.0.0
AppliedOn by @nathanpovo in https://github.com/fluentmigrator/fluentmigrator/pull/1847
MicrosoftBuildLogger. by @teo-tsirpanis in https://github.com/fluentmigrator/fluentmigrator/pull/1905The main area we could use help right now is with fluentmigrator/documentation repository and automating the documentation release process further. Additionally, fixing build related warnings for missing MSDoc comments would be extremely appreciated.
Full Changelog: https://github.com/fluentmigrator/fluentmigrator/compare/v6.2.0...v7.0.0
Use of standard dependency injection, configuration and logging libraries. Simplification of in-process runner configuration and instantiation. Minimu
Use of standard dependency injection, configuration and logging libraries. Simplification of in-process runner configuration and instantiation. Minimum .NET Framework version is 4.8, see https://aka.ms/msbuild/developerpacks for more information.
Details: https://github.com/fluentmigrator/fluentmigrator/releases
Full Changelog: v6.1.4...v6.2.0
Full Changelog: https://github.com/fluentmigrator/fluentmigrator/compare/v6.1.4...v6.2.0
Use of standard dependency injection, configuration and logging libraries. Simplification of in-process runner configuration and instantiation. Minimu
Use of standard dependency injection, configuration and logging libraries. Simplification of in-process runner configuration and instantiation. Minimum .NET Framework version is 4.8, see https://aka.ms/msbuild/developerpacks for more information.
Details: https://github.com/fluentmigrator/fluentmigrator/releases
Full Changelog: v6.1.3...v6.1.4
Full Changelog: https://github.com/fluentmigrator/fluentmigrator/compare/v6.1.3...v6.1.4
Use of standard dependency injection, configuration and logging libraries. Simplification of in-process runner configuration and instantiation. dotnet
Use of standard dependency injection, configuration and logging libraries. Simplification of in-process runner configuration and instantiation. dotnet-fm is now a global .NET Core 2.1 tool. Minimum .NET Framework version is 4.6.2, see https://aka.ms/msbuild/developerpacks for more information.
Details: https://github.com/fluentmigrator/fluentmigrator/releases
Full Changelog: v6.1.1...v6.1.2
Full Changelog: https://github.com/fluentmigrator/fluentmigrator/compare/v6.1.1...v6.1.2
Use of standard dependency injection, configuration and logging libraries. Simplification of in-process runner configuration and instantiation. dotnet
Use of standard dependency injection, configuration and logging libraries. Simplification of in-process runner configuration and instantiation. dotnet-fm is now a global .NET Core 2.1 tool. Minimum .NET Framework version is 4.6.2, see https://aka.ms/msbuild/developerpacks for more information.
Details: https://github.com/fluentmigrator/fluentmigrator/releases
Full Changelog: v6.1.0...v6.1.1
Full Changelog: https://github.com/fluentmigrator/fluentmigrator/compare/v6.1.0...v6.1.1
Use of standard dependency injection, configuration and logging libraries. Simplification of in-process runner configuration and instantiation. dotnet
Use of standard dependency injection, configuration and logging libraries. Simplification of in-process runner configuration and instantiation. dotnet-fm is now a global .NET Core 2.1 tool. Minimum .NET Framework version is 4.6.2, see https://aka.ms/msbuild/developerpacks for more information.
Details: https://github.com/fluentmigrator/fluentmigrator/releases
Full Changelog: https://github.com/fluentmigrator/fluentmigrator/compare/v6.0.0...v6.1.0
Bump dependency Npgsql from 8.0.1 to 8.0.3 * SECURITY VULNERABILITY by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/1817
Full Changelog: https://github.com/fluentmigrator/fluentmigrator/compare/v5.2.0...v6.0.0
Bump McMaster.Extensions.CommandLineUtils from 4.1.0 to 4.1.1 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1736
Version 6.0.0 will be released and remove all obsolete code from the code-base. Feel free to help submit PRs as part of the 2024 Spring Cleaning 🌤️ 🧹 🎉
Full Changelog: https://github.com/fluentmigrator/fluentmigrator/compare/v5.1.0...v5.2.0
Improve sample code to explicitly configure nullable. by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/1708
Bump Snowflake.Data from 2.1.3 to 2.1.5 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1701
Bump Npgsql from 8.0.0 to 8.0.1 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1700
Bump NUnit from 3.14.0 to 4.0.1 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1695
Bump FSharp.Core from 8.0.100 to 8.0.101 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1713
Bump MySqlConnector from 2.3.1 to 2.3.2 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1704
Bump MySqlConnector from 2.3.2 to 2.3.5 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1720
Bump AutoMapper from 12.0.1 to 13.0.0 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1725
Bump Oracle.ManagedDataAccess.Core from 3.21.120 to 3.21.130 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1711
Bump Oracle.ManagedDataAccess from 21.12.0 to 21.13.0 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1710
Full Changelog: https://github.com/fluentmigrator/fluentmigrator/compare/v5.0.0...v5.1.0
Everything marked as deprecated in this release will be permanently removed in 6.0.0. Plan accordingly.
IDeleteExpressionRoot interface method IInSchemaSyntax Table(string tableName) is now IIfExistsOrInSchemaSyntax Table(string tableName). The consequence of this is that it is not possible to run 3.x migrations against the 5.0 runner if you reference a Delete expression, with the exception error message Method not found: 'FluentMigrator.Builders.IInSchemaSyntax FluentMigrator.Builders.Delete.IDeleteExpressionRoot.Table(System.String)' (see commit b758e9cbbc8d2e625cf470d7d604ce57236b4e30 for technical details).In general, we can't provide a backwards compatible interface for this, since C# does not support return type covariance.
In general, we can't provide a backwards compatible interface for this, since C# does not support return type covariance.
FluentMigrator now supports .NET 8! FluentMigrator now supports Snowflake, thanks to Ellis Kenyo in the following commit https://github.com/fluentmigrator/fluentmigrator/commit/7f1260090cda412a68c292eb704285065c5cce74 and merged in via 734aa5c588e28717695c0b7045a44ef86dc6db7d Add categories for all tests #671 by @eloekset
table_info by @mattbrailsford in https://github.com/fluentmigrator/fluentmigrator/pull/1580Full Changelog: https://github.com/fluentmigrator/fluentmigrator/compare/v3.3.2...v5.0.0
https://github.com/fluentmigrator/fluentmigrator/milestone/34
#1528 Add support for Postgres Insert statement "OVERRIDING { SYSTEM | USER } VALUE"
https://github.com/fluentmigrator/fluentmigrator/milestone/34
# 🐞 Fixes #1515 : Limited query to current database to fix #1114 (When Renaming a column in MySQL, it may use column definition from another table). F
#1515 : Limited query to current database to fix #1114 (When Renaming a column in MySQL, it may use column definition from another table). Fixed by @x3ntrix ; reported by @socolin
# Improvements #1507 : Additional tool support for TFMs (@slang25 )
#1507 : Additional tool support for TFMs (@slang25 )
# Bug Fixes 🐞 #1487 : Fixes error to add default value for Json (@lillo42) (Fixes #1457 : FormatException with creating column with default json value
#1487 : Fixes error to add default value for Json (@lillo42) (Fixes #1457 : FormatException with creating column with default json value ("{}") (@kroliczek94))
https://github.com/fluentmigrator/fluentmigrator/milestone/44?closed=1
#1478 : Password to SQL Server is logged as plaintext when connection string contains whitespace around quality mark. (Fixes #1479) (@wiciok) #1449 : SAP Hana - Wrong Column Type Mapping (Fixes #1447) (@Mosheh)
#1414 : Postgres add support for tablespace (@lillo42) (Partially fixes #967 - PRs welcome to continue support for other DBs!) #1433 : Improve docs on PostgreSQL Extensions (@lillo42)
#1459 : Upgrade to GitHub-native dependabot
#1436 Replace usage of System.Data.SqlClient with Microsoft.Data.SqlClient (Fixes #1023)
https://github.com/fluentmigrator/fluentmigrator/milestone/44?closed=1
#1424 : Temporary workaround for runtime and local assembly loading (@OneThatWalks) Fixes #1406 Could not load file or assembly 'System.Runtime, Versi
#1424 : Temporary workaround for runtime and local assembly loading (@OneThatWalks) Fixes #1406 Could not load file or assembly 'System.Runtime, Version=4.2.2.0 ...
The previous two releases, Version 3.2.12 and Version 3.2.13, was skipped due to a build error. Since we don't delete tags, we are creating new releas
The previous two releases, Version 3.2.12 and Version 3.2.13, was skipped due to a build error. Since we don't delete tags, we are creating new release notes and incrementing the patch number from 12 to 14. Below are the new release notes, with fix #1421 added to address build errors.
#1411 Oracle: Log SQL on Error. Error Handling code now shared via ProcessorBase. (@robertwilliams2000)
#1404 Postgres - Index - Add support for Index Storage parameters (@lillo42)
#1421 Fixes stack-overflow error in using Postgres FillFactor option (@lillo42) : Fixes #1416
#1423 Replace legacy myget feed with AzureDevOps feed (@jzabroski)
# Postgres Changes #1397 : Add support for nulls last/first on column (@lillo42) #1399 : Fixes error to create a index with index method (@lillo42)
#1397 : Add support for nulls last/first on column (@lillo42) #1399 : Fixes error to create a index with index method (@lillo42)
Postgres Extension .AsOnly() for Only, .AsConcurrently() for Concurrently.
#1334 : SQLiteProcessor now takes a SQLiteQuoter instance (@AndrewKitu)
#1385 : Postgres add support for CONCURRENTLY and ONLY
.AsOnly() for Only, .AsConcurrently() for Concurrently..AsConcurrently() in a transaction context will fail.#1386 : Postgres add support for partial index (Fixes #1367: Add support for PgSQL partial indexes)
.Filter() will allow partial indexes (aka filtered indexes), similar to SQL Server#1362 : Add Postgres include for index (@lillo42)
.Include() On Postgres <11 will throw NotSupportedException. Use IfDatabase if this is intended.#1366 : Add Postgres .Using() index method (@lillo42)
.Using(Algorithm.BTree)#1382 : Add Support for MysqlConnector 1 namespace changes #1394 : Add Postgres 10/11 for FluentMigrator.DotNet.CLI
#1334 : Fix SQLite message about incorrect double quotes (Frédéric Vaillancourt) #1334 : Fix issue with single quote in SQLite TableExists (Frédéric Vaillancourt) #1350 : update test libs (@SimonCropp) #1354 : Removing GUID from test project as it's not needed since VS 15.7 (@BigYellowHammer) #1355 : Rename Directory.Buiild.props to Directory.Build.props (@PhenX)
#1328 : Fix some typos (@AndrewKitu) #1329 : Fix yet another typo series (@AndrewKitu) #1330 : Use 'nameof' expression to reference name (@AndrewKitu) #1331 : Fix variable names (readability improvement) (@AndrewKitu)
DbTransactions belonging to a SqlConnection instance. Goal is to better support disconnected scenarios where users cannot run FluentMigrator.DotNet.Cli or FluentMigrator.Console against a production database.#1319 - Support OutputSemicolonDelimiter Config Option for Console Runner (@manu-m) #1325 - Enhance description to disable flag that has default value
#1319 - Support OutputSemicolonDelimiter Config Option for Console Runner (@manu-m)
#1325 - Enhance description to disable flag that has default value = true (@igitur)
#1324 - Remove unnecessary Microsoft.Data.Sqlite dependencies to a lot of the projects. (@igitur)
#1322 - Oracle: fix query in SequenceExists (@emejibka)
#1261 - Oracle: add schemaName to sql for create index expressions (@emejibka)
#1272 - Add support for Postgres 10 Identity fields (@Sohra) cf #1084 (@EduAlbSantos alternative proposal that was built and deserves noteworthy prais
#1272 - Add support for Postgres 10 Identity fields (@Sohra) cf #1084 (@EduAlbSantos alternative proposal that was built and deserves noteworthy praise for effort) #1287 - Add Schema Name to OracleGenerator (@emejibka) R/t #1261 #1286 - Support SequenceExists test for OracleProcessorBase (@emejibka) R/t #1261 #1291 - Sqlite rename column (@Chandler-Davidson). R/t #1290 #1266 - Fix OracleException ORA-01704 string literal too long. (@fairking) R/t bug from #1265 #1296 - Add option to output semicolon delimiter (@pedrofernandesfilho) R/t bug from #765 #1283 - Connection string Password is not replaced (@jzabroski) R/t bug from #1283 (@benjaminrupp) #1289 - Fully Deterministic Build with SourceLink (@jzabroski) #1278 - Can't create a unique filtered index with included columns. (@jzabroski) R/t bug from #1278 (@Powerz) #1304 - PostgreSQL: DbType 'DateTimeOffset' Validate Precision (@jzabroski) R/t bug from @ikusmart)
#1210 : AddFluentMigratorCore() - Only register default IConventionSet if none registered yet. (@tgharold) Fixes #1194. (@rodrigoramos) #1257 : Displa
#1210 : AddFluentMigratorCore() - Only register default IConventionSet if none registered yet. (@tgharold) Fixes #1194. (@rodrigoramos)
#1257 : Display preview-only mode header when running migrate:down (@sowings13)
#1253 : Do not use Console.WriteLine. (@pergardebrink) Fixes #1252 (@YeskaNova)
#1243 : Add description to sql statement expression. (@pergardebrink) Addresses feature request #1242 How to remove sensitive information (ex: passwords) from the output (@andrecarlucci)
#1130 : Add unmapped subcommands for FluentMgirator.DotNet.Cli. Fixes #1123 dotnet fm rollback all does not work . Documentation was also updated in https://github.com/fluentmigrator/documentation/pull/19 @gandarez
#1196 : Fix large string literals oracle @PhenX
#1187 : Adds tests to reproduce the infinite loop issue in #970 (@PeterKneale)
#1081 : Support for MSSQL index filters and data compression (@gliljas)
This release is exactly like release 3.2.5. It's created just to get our build and release pipelines work correctly, ref issue #1213.
This release is exactly like release 3.2.5. It's created just to get our build and release pipelines work correctly, ref issue #1213.
Nothing published for this version
You're now able to disable stripping of comments with the option --strip:false.
You're now able to disable stripping of comments with the option --strip:false.
Runner: Default schema name can be set (PR #907)
WithGlobalConnectionString accepting a lambda for lazy connection string query (PR #919)PostgresOptions.ForceQuote to falseForce Quote=falseForce Quote=trueCurrentVersionMigrationConstraint to ensure that this
migration only gets run when the database version is greater or equal
than the given number. This allows some kind of migrations that will only
be executed when a conversion is necessary.IConventionSet loaded from given assemblies (Issue #916)RunnerOptions.StartVersion (PR #992)// instead of # for comments (Issue #859)# for comments (Issue #859)# for comments (Issue #859)Execute.WithConnection delegate (Issue #1001)Migration loader doesn't try to load profiles anymore (fixes #904)
Avoid duplicate Dispose calls (fixes #901)
The FluentMigrator.Console package doesn't depend on the FluentMigrator package, because it's already included
An upgrade guide is available here:
An upgrade guide is available here:
https://fluentmigrator.github.io/articles/guides/upgrades/guide-3.0-to-3.1.html
IFilteringMigrationSource to avoid unnecessary instantiationsIVersionTableMetaDataSourceItem to specify multiple places to search for version table metadatadotnet-fm and Migrate.exe are now referencing FSharp.Core which should ease the problems with F# (issue #883).IConfigurationRoot for the connection string if IConfiguration couldn't be founddotnet-fm now uses the Oracle beta ADO.NET driverOracle plans to release a non-beta version of the driver in Q3, but
it's the only Oracle driver that works under Linux/MacOS. The console
tool (Migrate.exe) is more Windows-centric and will therefore keep
using the standard Oracle ADO.NET library. The dotnet-fm is mostly
used on non-Windows platforms and is therefore predestinated to use
the new beta driver.
The statement from Oracle can be found on the Oracle website.
The console tool will switch to the new driver when it becomes stable.
var services = new ServiceCollection()
.AddFluentMigratorCore()
.ConfigureRunner(rb => rb
.AddSQLite()
.ScanIn(typeof(YourType).Assembly));
// There is a fluent interface to configure the targets for ScanIn
Configurations for ScanIn(assemblies):
--+-------------------------------------------+->
| ^
| |
+- For -+- All() ---------------------------+
^ | ^
| | |
| +- Migrations() ------------+-->+-->+
| | ^ |
| | | |
| +- VersionTableMetaData() --+ |
| | ^ |
| | | |
| +- EmbeddedResources() -----+ |
| |
| v
+<--------------------------------------+
Example:
var services = new ServiceCollection()
.AddFluentMigratorCore()
.ConfigureRunner(rb => rb
.AddSQLite()
.ScanIn(typeof(YourType).Assembly)
.For.Migrations()
.For.EmbeddedResources());
// There is a fluent interface to configure the targets for ScanIn
This allows the reconfiguration of the connection string/used database at run-time.
The following option classes are now resolved using IOptionSnapshot<T>:
ProcessorOptionsSelectingProcessorAccessorOptionsSelectingGeneratorAccessorOptionsTypeFilterOptionsThe following services are now scoped instead of singleton:
IVersionTableMetaDataAccessorIVersionTableMetaDataIMigrationSourceIMigrationInformationLoaderThe MigrationSource now consumes all registered IMigrationSourceItem instances.
AppConfigConnectionStringAccessorOptions to allow leading the connection strings from the *.config xml file (deprecated, only for transition to Micros…
The new documentation is online on https://fluentmigrator.github.io.
https://fluentmigrator.github.io/articles/guides/upgrades/guide-2.0-to-3.0.html
ProcessorOptions.Timeout is now of type System.TimeSpan?MigrationRunner.MaintenanceLoader is now read-onlyMigrationRunner.CaughtExceptions returns now a IReadOnlyListdotnet-fm is now a global tool and requires at least the .NET Core tooling 2.1-preview2IConfiguration service (Microsoft.Extensions.Configuration)IMigrationExpressionValidator for custom migration expression validationNULL constraint for custom types for PostgreSQL and SQL ServerIAssemblyCollection and all its implementationsIAnnouncer and all its implementationsIMigrationRunnerConventions.GetMigrationInfoIProfileLoader.ApplyProfiles()IProfileLoader.FindProfilesInIMigrationProcessorOptionsIMigrationProcessorFactory and all its implementationsIRunnerContext and RunnerContext, replaced by several dedicated options classes:
RunnerOptions are the new RunnerContext (minus some properties extracted into separate option classes)ProcessorOptions for global processor-specific optionsGeneratorOptions to allow setting the compatibility modeTypeFilterOptions for filtering migrations by namespaceAnnouncerOptions to enable showing SQL statements and the elapsed timeSelectingProcessorAccessorOptions allows selection of a processor by its identifierSelectingGeneratorAccessorOptions allows selection of a generator by its identifierAppConfigConnectionStringAccessorOptions to allow leading the connection strings from the *.config xml file (deprecated, only for transition to Microsoft.Extensions.Configuration)CompatabilityMode (is now ComatibilityMode)ApplicationContext in various interfaces/classesManifestResourceNameWithAssembly replaced by ValueTupleMigrationGeneratorFactoryMigrationProcessorFactoryProviderITypeMap.GetTypeMap(DbType, int, int)IDbFactory: Only the implementations will remainThe library assumes that in ProcessorOptions.ConnectionString is either a connection string or
a connection string identifier. This are the steps to load the real connection string.
IConnectionStringReader implementations
IConnectionStringReaderProcessorOptions.ConnectionStringThe connection string stored in ProcessorOptions.ConnectionString might be overridden
by registering the IConnectionStringReader instance PassThroughConnectionStringReader
as scoped service.
When no connection string could be found, the SelectingProcessorAccessor returns
a ConnectionlessProcessor instead of the previously selected processor.
// Initialize the services
var serviceProvider = new ServiceCollection()
.AddLogging(lb => lb.AddFluentMigratorConsole())
.AddFluentMigratorCore()
.ConfigureRunner(
builder => builder
.AddSQLite()
.WithGlobalConnectionString(connectionString)
.WithMigrationsIn(typeof(AddGTDTables).Assembly))
.BuildServiceProvider();
// Instantiate the runner
var runner = serviceProvider.GetRequiredService<IMigrationRunner>();
// Run the migrations
runner.MigrateUp();
This adds the FluentMigrator services to the service collection and configures the runner to use SQLite with the given connection string, announcer and migration assembly.
Now you can instantiate the runner using the built service provider and use its functions.
### Added - #856 New constructors to enable passing a custom expression convention set
### Fixed - #859: The pound sign is only recognized when it's only preceeded by whitespace
net452 build for the console runner to enable usage of the latest MySQL ADO.NET provider
tools/net452/x86/Migrate.exe)This has become necessary to enable a better out-of-the-box experience for the migration tool.
Unlisted due to unintentional breaking change.
Unlisted due to unintentional breaking change.
### Fixed - #858: Don't even try to set the command timeout for SQL Server CE
- #856: Don't fail when an assembly couldn't be loaded - #848: MySql4ProcessorFactory used the MySql5Generator
MySql4ProcessorFactory used the MySql5GeneratorFluentMigrator.Console now contains the migration tool in the tools/ directory (fixes #846)
FluentMigrator.Console now contains the migration tool in the tools/ directory (fixes #846)FluentMigrator.Tools package added as upgrade pathFluentMigrator.Console now contains the migration tool in the tools/ directoryFluentMigrator.Tools package added as upgrade pathShow (BREAKING) for migrations with breaking changes
IQuerySchema.DatabaseType now returns SqlServer2016, etc... and not SqlServer any moreIMigrationConventions was renamed to IMigrationRunnerConventionsIMigrationContext doesn't contain the IMigrationConventions any more
IConventionSetICanBeConventional was removed during the overhaul of the expression convention systemNonUnicodeString for ANSI stringsFluentMigrator.Tools was split into the following packages
FluentMigrator.Console: The Migrate.exe toolFluentMigrator.MSBuild: The MSBuild Migrate taskALTER/DROP DEFAULT value supportNVARCHAR for AsStringWITH (ONLINE=ON/OFF) supportForce Quote=true to enforce quotesSetExistingRowsTo supports SystemMethodsStopOnError flagFluentMigrator.Runner to FluentMigrator.Runner.<Database>FluentMigrator.Extensions.SqlServer(not applied) for unapplied migrations(BREAKING) for migrations with breaking changesIAnnouncer.WriteTagAttribute by inheritanceSqlBatchParser to parse batches of SQL statements (GO statement support)One column per quarter.