What's Changed

Contributions

• Improve sample code to explicitly configure nullable. by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/1708
• Use configured quoter in SQLiteColumn by @lrobin136 in https://github.com/fluentmigrator/fluentmigrator/pull/1712
• Upgrade Microsoft.Data.SqlClient version 5.1.2 to 5.1.4 by @robert-lilleker in https://github.com/fluentmigrator/fluentmigrator/pull/1723
• Fixes #1259 Create.UniqueConstraint API should be as feature complete… by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/1707

Dependency updates

• 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

New Contributors

• @lrobin136 made their first contribution in https://github.com/fluentmigrator/fluentmigrator/pull/1712
• @robert-lilleker made their first contribution in https://github.com/fluentmigrator/fluentmigrator/pull/1723

Full Changelog: https://github.com/fluentmigrator/fluentmigrator/compare/v5.0.0...v5.1.0

What's Changed

Announcements

• Everything marked as deprecated in this release will be permanently removed in 6.0.0. Plan accordingly.

Breaking Changes

• Maintenance Migrations that are untagged are now included by default. See: #1689, which addresses various bug reports that would confuse quite a few users of FluentMigrator 3.x. The behavior is now consistent with regular Migrations.

End Of Life Support

• SQL Server Compact Edition has been dropped.
• SQL Anywhere has been dropped.
• Drop support for .NET 5 due to Microsoft End Of Life Support. by @jzabroski in 5c003e629d81a7c546e8090b7cc98c8bdaed6574

Big New Features

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

Other Changes

• Enhance FormatSystemMethods quoter with new DB2, Firebird, MySql features #1156 by @jzabroski in 00f76dd9064851130ca44c0f79480a8e5b636d5d
  Add IColumnTypeSyntax.AsType(DbType type) method for columns. Fixes #1085 by @jzabroski in a624ae08b423041a5b5dafd1101995dee78bf023
• SQLite Processor: Query column without loading whole table_info by @mattbrailsford in https://github.com/fluentmigrator/fluentmigrator/pull/1580
• Limit SQLite type mappings to the 4 core data types by @mattbrailsford in https://github.com/fluentmigrator/fluentmigrator/pull/1581
• Fixes SQLite FormatIdentity bug 1456 by @mattbrailsford in https://github.com/fluentmigrator/fluentmigrator/pull/1583
• Bump MySql.Data from 8.0.11 to 8.0.28 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1558
• Add missing features to SQLite runner by @mattbrailsford in https://github.com/fluentmigrator/fluentmigrator/pull/1585
• Adding additional description properties using additional list by @azerios in https://github.com/fluentmigrator/fluentmigrator/pull/1553
• Fixes #1592 by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/1593
• Fixes #1590 by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/1594
• Bump NUnit3TestAdapter from 3.17.0 to 4.2.1 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1586
• Bump Shouldly from 3.0.2 to 4.0.3 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1469
• Bump System.ValueTuple from 4.4.0 to 4.5.0 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1467
• Bump McMaster.Extensions.CommandLineUtils from 2.3.4 to 4.0.1 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1559
• Bump FSharp.Core from 4.6.2 to 6.0.3 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1596
• Add support for NullsDistinct() / NullsNotDistinct() for Postgres by @lillo42 in https://github.com/fluentmigrator/fluentmigrator/pull/1603
• Move all FluentMigration.Runner code to FluentMigrator.Runner.Core by @mattbrailsford in https://github.com/fluentmigrator/fluentmigrator/pull/1600
• Make Postgres 10 & 11 processors public by @rvdginste in https://github.com/fluentmigrator/fluentmigrator/pull/1615
• Add JetBrains.Annotations.MeansImplicitUse to MigrationAttribute by @sirduke in https://github.com/fluentmigrator/fluentmigrator/pull/1620
• feat: add dotnet 6.0 support for cli tool by @johannessorheim in https://github.com/fluentmigrator/fluentmigrator/pull/1650
• Correct help for preview switch by @ToddRopog in https://github.com/fluentmigrator/fluentmigrator/pull/1658
• feat: add dotnet 7.0 support for cli tool by @PauloDaniel1993 in https://github.com/fluentmigrator/fluentmigrator/pull/1656
• Use PackageLicenseExpression by @georg-jung in https://github.com/fluentmigrator/fluentmigrator/pull/1653
• Fix a typo in a couple of error messages by @adrianbanks in https://github.com/fluentmigrator/fluentmigrator/pull/1654
• Replace MySql.Data to MySqlConnector by @lillo42 in https://github.com/fluentmigrator/fluentmigrator/pull/1678
• Add Support to MySQL 8 and add MySql extensions by @lillo42 in https://github.com/fluentmigrator/fluentmigrator/pull/1680
• Bump JetBrains.Annotations from 11.1.0 to 2023.3.0 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1691
• Bump MySqlConnector from 2.2.7 to 2.3.1 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1692
• Bump Snowflake.Data from 2.1.3 to 2.1.4 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1697
• Bump Npgsql from 8.0.0 to 8.0.1 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1696
• Bump Moq from 4.20.69 to 4.20.70 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1693
• Fixes #1545: Postgres10_0 / Postgress11_0: When altering column, migrator ignores collation by @jzabroski in e6cbe629e3568286b95d61c455e24f8b6fc68bdc
• Fixes #1672 ConnectionlessProcessor NotImplementedException should state method name not supported. by @jzabroski in 1283d05dccc3a5e262e766e105b132912412949c, 25b6c20ef2832376635d3ef08bcfd94fb70b1137, & 06d82918255b2b66483053dddc5c13bda934bdc8
• Postgres quoter now supports SystemMethods.CurrentDateTimeOffset. by @fubar-coder in 0cf25c8b505c8315657eca3e5144c3f52e9249ec
• Postgres dependency injection tests. by @fubar-coder in aea546b6ea2f0585b0cbac4617ff38559a81d827

New Contributors

• @mattbrailsford made their first contribution in https://github.com/fluentmigrator/fluentmigrator/pull/1580
• @dependabot made their first contribution in https://github.com/fluentmigrator/fluentmigrator/pull/1558
• @azerios made their first contribution in https://github.com/fluentmigrator/fluentmigrator/pull/1553
• @rvdginste made their first contribution in https://github.com/fluentmigrator/fluentmigrator/pull/1615
• @sirduke made their first contribution in https://github.com/fluentmigrator/fluentmigrator/pull/1620
• @johannessorheim made their first contribution in https://github.com/fluentmigrator/fluentmigrator/pull/1650
• @ToddRopog made their first contribution in https://github.com/fluentmigrator/fluentmigrator/pull/1658
• @PauloDaniel1993 made their first contribution in https://github.com/fluentmigrator/fluentmigrator/pull/1656
• @georg-jung made their first contribution in https://github.com/fluentmigrator/fluentmigrator/pull/1653
• @adrianbanks made their first contribution in https://github.com/fluentmigrator/fluentmigrator/pull/1654

Full Changelog: https://github.com/fluentmigrator/fluentmigrator/compare/v3.3.2...v5.0.0

💯 Enhancements

#1528 Add support for Postgres Insert statement "OVERRIDING { SYSTEM | USER } VALUE"

See Also

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). Fixed by @x3ntrix ; reported by @socolin

Improvements

#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 ("{}") (@kroliczek94))

Fixes

#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)

Enhancements

#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)

Infrastructure

#1459 : Upgrade to GitHub-native dependabot

Breaking Changes

#1436 Replace usage of System.Data.SqlClient with Microsoft.Data.SqlClient (Fixes #1023)

Milestone Data

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, 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 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)

The previous release, Version 3.2.12, 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 13. 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

#1411 Oracle: Log SQL on Error. Error Handling code now shared via ProcessorBase. (@robertwilliams2000)
#1404 Postgres - Index - Add support for Index Storage parameters (@lillo42)

Postgres Changes

#1397 : Add support for nulls last/first on column (@lillo42)
#1399 : Fixes error to create a index with index method (@lillo42)

Breaking Changes

#1334 : SQLiteProcessor now takes a SQLiteQuoter instance (@AndrewKitu)

Features

#1385 : Postgres add support for CONCURRENTLY and ONLY

• Postgres Extension .AsOnly() for Only, .AsConcurrently() for Concurrently.
• Calling .AsConcurrently() in a transaction context will fail.

#1386 : Postgres add support for partial index (Fixes #1367: Add support for PgSQL partial indexes)

• Calling .Filter() will allow partial indexes (aka filtered indexes), similar to SQL Server

#1362 : Add Postgres include for index (@lillo42)

• Calling .Include() On Postgres <11 will throw NotSupportedException. Use IfDatabase if this is intended.

#1366 : Add Postgres .Using() index method (@lillo42)

• e.g., .Using(Algorithm.BTree)

#1382 : Add Support for MysqlConnector 1 namespace changes
#1394 : Add Postgres 10/11 for FluentMigrator.DotNet.CLI

Fixes

#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)

Readability Improvements

#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)

Design Proposals (Future Progress)

1. adr/proposed/DefaultSchema.md : Two users have requested different behavior for default schema for Postgres. We documented how different databases implement the concept of "default schema" to make progress towards enhancing default schema behavior in FluentMigrator.
2. Update adr/proposed/UnitOfWork.md : Progress on improving future design for how FluentMigrator handles logical transactions and physical 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 = 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 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 : 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.

Fixes #1209 (issue is with nuget.org FluentMigrator.Console package, only)

• Fixes #1132

• #970 Infinite loop when AggregateException is thrown
• #1037 Add explanation for Obsolete interfaces
• #1082 update default-schema-name argument to properly accept a value
• #1070 Fixing Oracle identity column type issues
• #1060 Support renaming columns in MariaDb 10.2
• #1058 Remove private XML asset Sap.Data.Hana.v4.5.dll.config
• #1042 Fix Oracle dialect create sequence NOCACHE
• #1027 Added ability for TagsAttribute to be applied to and inherited from interface