What's Changed

Features

• Added namespace filtering to maintenance migrations by@spopp23 in#2171
• Improve Execute.WithConnection PerformDBOperation logging with description parameter by @Copilot in#2159
• Add IDictionary support to Update data expressions by @Copilot in#2163
• NEW PACKAGE: FluentMigrator.Analyzers
  • Will warn if you have a duplicate migration version number.
  • Feature/analyzers by@PhenX in#1908
  • feat: Analyzers by@benmccallum in#1240

Bug Fixes

• Fix Snowflake CurrentDateTime to return TIMESTAMP_NTZ compatible value by @Copilot in#2149
• Fix duplicate clustered index issue when both CreateWithPrimaryKey and UniqueIndexName are set by @Copilot in#2160
• Fix WithGlobalConnectionString silent failure with invalid connection strings by @Copilot in#2157
• ADR: Statement Seperators by@jzabroski in#2046
• Make SqlServer2008TypeMap a public class by@jayharris in#2095
• Force integer formatting with invariant culture (fixes#2063) by@PhenX in#2118
• Fixes#2020: Remove Obsolete interfaces in FluentMigrator.Runner.Postgres by@jzabroski in#2024
• Sample code should have explicit dependabot.yml config by@jzabroski in#2032
• Fixes#2034: Make internal field MigrationBase._context private by@jzabroski in#2035
• Fixes#2054: Support Insert multiple rows from IEnumerable by@jayharris in#2086
• Fix automapper build break from upgrade to 15.0.0 by@jzabroski in#2123
• Fix sample by@jzabroski in#2122
• GitHub Actions + Coverlet Code Coverage + ubuntu container integration tests + Oracle N_CLOB fix on linux by@jzabroski in#2128
• Make Oracle integration tests run and fix Oracle single statement execution code by@PhenX in#2126
• Fix CS0518: Add IsExternalInit stub for netstandard2.0 in Analyzers by @Copilot in#2178
• Fix MySQL .AsTime() creating DATETIME column instead of TIME by @Copilot in#2190
• Fix RawSql backward compatibility in DELETE and UPDATE WHERE clauses by @Copilot in#2199

Breaking Changes

Runner Behavior Changes

• ListMigrations should not warn when current migration is listed by@jzabroski in#2155

Third Party Database Runners

• Replace DB2 dll with Net.IBM.Data.Db2 nuget package by@jzabroski in#2130
• Improve DB2 loading and fix build error from previous change. by@jzabroski in#2174

Possible ABI Breaking Changes

• Move IQuoter to FluentMigrator.Generation namespace; add compatibility wrapper instead of the TypeForwardedTo to eliminate Obsolete usage warnings by@PhenX in#2142

Removing Obsolete APIs

• 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

Dependency bumps

• Bump System.ValueTuple and Microsoft.NETFramework.ReferenceAssemblies by@dependabot[bot] in#2017
• Bump FluentMigrator.MSBuild and Microsoft.NETFramework.ReferenceAssemblies by@dependabot[bot] in#2016
• Bump the core-dependencies group with 2 updates by@dependabot[bot] in#2031
• Bump the database-driver-dependencies group with 2 updates by@dependabot[bot] in#2030
• Bump FluentMigrator.MSBuild and Microsoft.NETFramework.ReferenceAssemblies by@dependabot[bot] in#2028
• Bump the test-dependencies group across 1 directory with 4 updates by@dependabot[bot] in#2033
• Bump the database-driver-dependencies group with 3 updates by@dependabot[bot] in#2037
• Bump the other-dependencies group with 2 updates by@dependabot[bot] in#2040
• Bump the database-driver-dependencies group with 2 updates by@dependabot[bot] in#2039
• Bump the core-dependencies group with 10 updates by@dependabot[bot] in#2038
• Bump the database-driver-dependencies group across 1 directory with 7 updates by@dependabot[bot] in#2044
• Bump the test-dependencies group with 4 updates by@dependabot[bot] in#2043
• Bump the database-driver-dependencies group with 2 updates by@dependabot[bot] in#2045
• Bump the database-driver-dependencies group with 3 updates by@dependabot[bot] in#2047
• Bump the database-driver-dependencies group with 2 updates by@dependabot[bot] in#2048
• Add StatementFormat to handle more consistently semicolons by@PhenX in#2025
• Update Autofac to 8.3.0 by@dependabot[bot] in#2050
• Bump FSharp.Core from 9.0.202 to 9.0.303 by@dependabot[bot] in#2114
• Bump Microsoft.Extensions.Configuration.Binder and 7 others by@dependabot[bot] in#2110
• Bump the test-dependencies group with 10 updates by@dependabot[bot] in#2083
• Bump the runner-dependencies group with 1 update by@dependabot[bot] in#2109

Code Infrastructure Improvements / Code Style Clean-up

• Computed columns integration tests by@PhenX in#2131
• Use short get/set syntax for simple properties by@PhenX in#2121
• CS1591 warnings by@jzabroski in#2139
• Create copilot-instructions.md by@jzabroski in#2151
• Change pull_request to pull_request_target event by@jzabroski in#2156
• Improve PR pipeline: more integration envs and test infos to the pipeline by@PhenX in#2148
• Enhance GitHub Actions to build on ubuntu-latest and windows-latest by @Copilot in#2162
• docs: fix typos in some files by@khanhkhanhlele in#2172
• Limit CI test targets by OS: run net8.0 on Linux and net48 on Windows only by@spopp23 in#2173
• Fix .NET Framework 4.8 Developer Pack installation with dynamic URL resolution by @Copilot in#2187
• Update azure-pipelines-pullrequests.yml by@jzabroski in#2096
• Update dependabot.yml by@jzabroski in#2112

New Contributors

• @jayharris made their first contribution in#2095
• @Copilot made their first contribution inhttps://github.com/fluentmigrator/fluentmigra...

Contributors

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 namedProcessorIdConstants. There is now a parallelGeneratorIdConstants 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 registersPostgresProcessor andPostgresGenerator (the base interfaces). It will now always register the "latest" database version. Currently,Postgres15_0Processor andPostgres15_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

Contributors

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 ofAppliedOn 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

• ImproveMicrosoftBuildLogger. 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...

Contributors

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

Contributors

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

Contributors

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

Contributors

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

Contributors

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

Contributors

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

Contributors

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

Contributors