What's Changed

New Features

As part of fixing #2018, IMigrationGenerator now has explicit GeneratorId and GeneratorIdAliases properties.

Bug Fixes

• Fixes #2018 SelectingGeneratorAccessor cannot find Alternative Identifiers "Postgres" and "SqlServer" by @jzabroski in #2023

Planned Obsolesence

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.

Breaking Changes

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

What's Changed

• FluentMigrator.MSBuild and FluentMigrator.DotNet.Cli now support .net 9.0
• Support for net6.0 and net7.0 is dropped, as it is end of life by Microsoft.
• FluentMigrator now has a detailed integration testing suite that runs tests on docker containers using images provided by every major database provider (where possible). Thanks to @PhenX
• Bug fixes
• Dependency updates
• Minor improvements

End of Life Support Changes

• Remove net6.0 and net7.0 support. Support net8.0 by @jzabroski in #1986

Bug fixes

• RawSql.Insert cannot be used as entire Where clause or Set clause in UpdateDataExpression/DeleteDataExpression by @PhenX in #1904
• Fix auto reversing with insert data by @AdrianoRNascimento in #1963
• Typo: No migration generator registerd -> "registered" by @jzabroski in #1926

Removing Code that has been marked Obsolete for 7 years :) 🥳

• Remove Obsolete DeleteIndexExpressionBuilder.CurrentColumn by @jzabroski in #1993
• Remove IAssemblyCollection and associated obsolete constructors/properties by @jzabroski in #1995
• Remove most of LegacyExtensions functionality by @jzabroski in #1997
• Remove IMigrationRunner.RunnerContext and MigrationRunner.RunnerContext by @jzabroski in #1999
• Remove obsolete ctor on DefaultConventionSet by @jzabroski in #2003
• Please Support .NET 9 in FluentMigrator.DotNet.Cli by @jzabroski in #2013

Dependency Injection improvements

• #1836: Support custom IVersionTableMetaData DI registration before AddFluentMigratorCore call by @warappa in #1842

Generator improvements

• Use database function to set the value of AppliedOn by @nathanpovo in #1847
  • This will especially help users who use preview scripts generated via the connectionless processor, for environments where scripts are reviewed by DBAs prior to being deployed to production.

MySQL improvements

• Added support for typeMap injection in MySqlGenerator by @maxc0de in #1914
• Correct AddMySql8 XML Documentation by @vermiceli in #1935
• Incorrect syntax for renaming a column with a default method in MySQL #1911 (Fix Column Renaming Syntax for MySQL 8) by @Cretesh-Anuj in #1945

FluentMigrator.MSBuild improvements

• Improve MicrosoftBuildLogger. by @teo-tsirpanis in #1905
• Add AllowDirtyAssemblies switch to MSBuild custom task by @jzabroski in #1903
• Address build failure from FluentMigrator.MSBuild sample by @jzabroski in #1906
• Add comment explaining use of TargetFrameworks vs. TargetFramework by @jzabroski in #1909
• Update FluentMigrator.Example.MSBuild.csproj by @jzabroski in #1913

Testing improvements

• Use test containers to facilitate running various integration tests by @PhenX in #1931
• Feature/nunit testcasesource by @PhenX in #1984
• Add justification to all Assert.Ignore calls when processor is not en… by @PhenX in #2001

Dependency Bumps

• Bump Microsoft.Data.Sqlite from 8.0.8 to 8.0.10 in the database-driver-dependencies group by @dependabot in #1915
• Bump the core-dependencies group with 6 updates by @dependabot in #1916
• Bump NUnit.Console from 3.18.2 to 3.18.3 in the test-dependencies group by @dependabot in #1917
• Bump FSharp.Core from 8.0.400 to 8.0.401 in the other-dependencies group by @dependabot in #1918
• Bump Autofac from 8.1.0 to 8.1.1 in the core-dependencies group by @dependabot in #1923
• Bump the database-driver-dependencies group across 1 directory with 2 updates by @dependabot in #1928
• Bump JetBrains.Annotations from 2024.2.0 to 2024.3.0 in the other-dependencies group by @dependabot in #1930
• Bump Snowflake.Data from 4.1.0 to 4.2.0 in the database-driver-dependencies group by @dependabot in #1933
• Bump FSharp.Core from 8.0.401 to 9.0.100 in the other-dependencies group by @dependabot in #1938
• Bump the core-dependencies group with 7 updates by @dependabot in #1937
• Bump the database-driver-dependencies group across 1 directory with 4 updates by @dependabot in #1936
• Bump NUnit.Analyzers from 4.3.0 to 4.4.0 in the test-dependencies group by @dependabot in #1939
• Bump SourceLink.Embed.AllSourceFiles from 2.8.0 to 2.8.3 by @dependabot in #1947
• Update dependabot.yml by @jzabroski in #1970
• Bump SourceLink.Create.CommandLine from 2.8.0 to 2.8.3 by @dependabot in #1948
• add code coverage badge by @jzabroski in #1844
• Bump SourceLink.Copy.PdbFiles from 2.8.0 to 2.8.3 by @dependabot in #1946
• Bump the database-driver-dependencies group across 1 directory with 3 updates by @dependabot in #1956
• Bump the test-dependencies group across 1 directory with 4 updates by @dependabot in #1957
• Bump the test-dependencies group across 1 directory with 6 updates by @dependabot in #1972
• Bump the other-dependencies group with 2 updates by @dependabot in #1971
• Bump the core-dependencies group across 1 directory with 11 updates by @dependabot in #1974
• Bump the database-driver-dependencies group with 6 updates by @dependabot in #1978
• Bump the test-dependencies group with 2 updates by @dependabot in #1979
• Bump the database-driver-dependencies group with 3 updates by @dependabot in #1987
• Bump AutoMapper from 13.0.1 to 14.0.0 by @dependabot in #1988
• Microsoft.Data.SqlClient netstandard2.0 TFM support is "end of life" by @jzabroski in #1989
• Update Microsoft.Extensions.* packages: 8.0.0 -> 9.0.2 by @jzabroski in #1990
• Bump the database-driver-dependencies group with 2 updates by @dependabot in #2005
• Bump the database-driver-dependencies group with 3 updates by @dependabot in #2011
• Bump the core-dependencies group with 10 updates by @dependabot in #2012

Continuous Integration / Continuous Delivery improvements

• Update azure-pipelines.yml by @jzabroski in #1922
• Create GH Action to update TargetFramework weekly by @jzabroski in #1980
• Update update-targetframework.yaml by @jzabroski in #1985

Documentation improvements

• #1924 Replaced gitter.im references with github discussions by @MichaelPGudz in #1929
• Update README.md by @jzabroski in #1976

New Contributors

• @teo-tsirpanis made their first contribution in #1905
• @maxc0de made their first contribution in #1914
• @nathanpovo made their first contribution in #1847
• @MichaelPGudz made their first contribution in #1929
• @vermiceli made their first contribution in #1935
• @Cretesh-Anuj made their first contribution in #1945
• @AdrianoRNascimento made their first contribution in #1963

Help Wanted

The main a...

What's Changed

• Bump Oracle.ManagedDataAccess from 23.5.1 to 23.6.0 in the database-driver-dependencies group by @dependabot in #1897
• #1884: Register ProcessorOptions explicitly, required by MigrationScopeHandler by @warappa in #1898
• Add MSBuild logging capability by @jzabroski in #1899
• Add support for parameters in Execute.Sql by @PhenX in #1900
• Turn on UseMsBuildLogging in sample MSBuild project by @jzabroski in #1902
• Add trace statements to MigrationSource task by @jzabroski in #1901

Full Changelog: v6.1.4...v6.2.0

What's Changed

• Update assembly versioning strategy by @jzabroski in #1894
• Update dependabot.yml by @jzabroski in #1895
• FluentMigrator.MSBuild packaging fixes

Full Changelog: v6.1.3...v6.1.4

What's Changed

• Update FluentMigrator.MSBuild.csproj by @jzabroski in #1893
  • If you use the net8.0 version of the task, make sure you are calling it with the .NET version of MSBuild and not the .NET Framework version of MSBuild. e.g., dotnet.exe msbuild /t:migrate

Full Changelog: v6.1.2...v6.1.3

What's Changed

• Update FluentMigrator.MSBuild to bundle deps the way Microsoft recommends by @jzabroski in #1892

Full Changelog: v6.1.1...v6.1.2

What's Changed

• FluentMigrator.MSBuild now explicitly targets net8.0 in an attempt to resolve #1891
• Update README.md by @jzabroski in #1890

Full Changelog: v6.1.0...v6.1.1

What's Changed

• Update dependabot.yml by @jzabroski in #1876
• Update dependabot.yml by @jzabroski in #1877
• Bump the other-dependencies group with 2 updates by @dependabot in #1882
• Bump the test-dependencies group with 6 updates by @dependabot in #1887
• Bump the core-dependencies group with 3 updates by @dependabot in #1886
• Update approach to packaging FluentMigrator.MSBuild by @jzabroski in #1889
• Bump the database-driver-dependencies group with 8 updates by @dependabot in #1885

Full Changelog: v6.0.0...v6.1.0

What's Changed

• Fixes #1183: MyGet Feed Is Obsolete - Switch to AzureDevOps by @jzabroski in #1769
• #1733: add readme for use in nuget readme documentation by @schambers in #1773
• Update azure-pipelines.yml by @jzabroski in #1774
• Fix #1426 iconUrl deprecated warnings by @jzabroski in #1771
• Fixes #1776: Remove Obsolete ApplicationContext by @jzabroski in #1777
• Fixes #1756: Remove obsolete property GenericGenerator.compatabilityMode by @jzabroski in #1764
• Bump version 5.2.0 by @jzabroski in #1775
• Fixes broken test on linux by @jzabroski in #1778
• Fixes #1506: SAP Hana - incorrect default type for boolean column by @jzabroski in #1770
• Remove obsolete pre-Dependency Injection factories by @jzabroski in #1782
• Update dependabot.yml by @jzabroski in #1786
• Update dependabot.yml by @jzabroski in #1787
• Revert Update dependabot.yml by @jzabroski in #1793
• Update dependabot.yml by @jzabroski in #1794
• Update MySQL SystemMethods.CurrentUTCDateTime to Use Expression by @etherfactor in #1797
• Create versioninfo table with primary key. by @vaital3000 in #1743
• Bump dependency Npgsql from 8.0.1 to 8.0.3 *** SECURITY VULNERABILITY by @jzabroski in #1817
• Remove unnecessary using statement in TypeMapper sample by @jzabroski in #1815
• Remove obsolete AutoScriptMigration interfaces; use IEmbeddedResourceProvider to get scripts by @jzabroski in #1816
• "NULLS NOT DISTINCT" for indexes in PostgreSQL 15+ by @Domanser in #1814
• Remove obsolete ExplicitUnicodeString by @jzabroski in #1821
• Clean up using statements by @jzabroski in #1820
• Add Brutal.Dev.StrongNamer reference to Tests project by @jzabroski in #1819
• Remove obsolete ctor on UpdateDataExpressionBuilder by @jzabroski in #1822
• Remove MigrationAssemblies by @jzabroski in #1824
• Remove obsolete validation logic, enhance DefaultMigrationExpressionValidator by @jzabroski in #1825
• Remove obsolete IMigrationProcessor.Options by @jzabroski in #1830
• Implement sequence existence check through the Schema by @dev-anton-ko in #1833
• Update azure-pipelines-pullrequests.yml by @jzabroski in #1854
• Bugfixes/1848 issues with non english culture by @warappa in #1849
• Patch system data sql client by @jzabroski in #1873
• Removed obsolete IProfileLoader.FindProfilesIn - this method has been a no-op for about seven years, so there should be no material impact
• Made ProfileLoader constructor obsolete and replaced it with a constructor that does not take IServiceProvider as a dependency

New Contributors

• @etherfactor made their first contribution in #1797
• @vaital3000 made their first contribution in #1743
• @Domanser made their first contribution in #1814
• @dev-anton-ko made their first contribution in #1833
• @warappa made their first contribution in #1849

Full Changelog: v5.2.0...v6.0.0

What's Changed

Dependency Bumps

• Bump McMaster.Extensions.CommandLineUtils from 4.1.0 to 4.1.1 by @dependabot in #1736
• Bump McMaster.Extensions.CommandLineUtils from 4.1.0 to 4.1.1 by @jzabroski in #1765
• Bump AutoMapper from 13.0.0 to 13.0.1 by @dependabot in #1729
• Bump MySqlConnector from 2.3.5 to 2.3.6 by @dependabot in #1753
• Bump FSharp.Core from 8.0.101 to 8.0.200 by @dependabot in #1734

Enhancements

• Make TypeMap Injectable #1755 by @jzabroski in #1757

Bug Fixes

• Properly dispose of ServiceProvider upon completed migrations by @schambers in #1748
• #1737: Don't apply AUTOINCREMENT on non-identity PK by @schambers in #1744
• Replace crlf with Environment.Newline by @schambers in #1752
• Fix sqlite multiple primary keys by @jzabroski in #1758
• Fixes #1740: Example creating index with multiple includes by @jzabroski in #1763

Copyright updates

• Update all license notices to 'Fluent Migrator Project' by @schambers in #1745

New Contributors

• @schambers made their first contribution in #1745

What's Next

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: v5.1.0...v5.2.0