Version 8.0.1

What's Changed

• Fix documentation for custom version table implementation and metadat… by @PhenX in #2218
• Add ADR for column visibility feature by @Copilot in #2222
• Remove obsolete IDbFactory interface references and clean up DbFactor… by @PhenX in #2216
• Add PostgreSQL security labels support by @PhenX in #2213
• Fix Snowflake migrations for #2113 by @scooby359 in #2224
• Add compatibilityMode parameter to AddSQLite extension method by @Copilot in #2227

New Contributors

• @scooby359 made their first contribution in #2224

Full Changelog: v8.0.0...v8.0.1

Milestone log: https://github.com/fluentmigrator/fluentmigrator/milestone/62

Version 8.0.0 (.NET 10 Support)

What's Changed

• Fix IQuoter obsoletion warnings by @PhenX in #2192
• Add documentation for Analyzers, namespace filtering, and IDictionary support by @Copilot in #2191
• Add .NET 10 support by @Copilot in #2188
• Refactor: Update ColumnBase to use generic type and fix deprecation w… by @PhenX in #2193
• Remove duplicate line in TypeMapper sample by @Copilot in #2203
• Fix AutoReversingMigration for Alter.Table().AddColumn() by @Copilot in #2197
• Fix Oracle Execute.Sql for PL/SQL blocks with BEGIN/END by @Copilot in #2204
• Ignore NUnit1034 warning to make Postgres11_0IndexTests abstract by @Copilot in #2207
• Add if condition to Upload Test Result Files step to handle test failures by @Copilot in #2209
• Fix IPostgresTypeMap DI injection support by @Copilot in #2196
• Add Umami website ID to config by @PhenX in #2210
• Update code analysis packages by @PhenX in #2211
• Fixes conflicting versions by @PhenX in #2214
• Adjust concurrent execution settings for FluentMigrator analyzers to … by @PhenX in #2215

Full Changelog: v7.2.0...v8.0.0

Milestone log: https://github.com/fluentmigrator/fluentmigrator/milestone/61

Version 7.2.0

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 in https://github.com/fluentmigrator/fluentmigra...

v7.1.0

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

v7.0.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...

Version 6.2.0

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

Version 6.1.4

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

Version 6.1.3

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

Version 6.1.2

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

Version 6.1.1

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