What's Changed

Dependency Bumps

• Bump McMaster.Extensions.CommandLineUtils from 4.1.0 to 4.1.1 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1736
• Bump McMaster.Extensions.CommandLineUtils from 4.1.0 to 4.1.1 by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/1765
• Bump AutoMapper from 13.0.0 to 13.0.1 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1729
• Bump MySqlConnector from 2.3.5 to 2.3.6 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1753
• Bump FSharp.Core from 8.0.101 to 8.0.200 by @dependabot in https://github.com/fluentmigrator/fluentmigrator/pull/1734

Enhancements

• Make TypeMap Injectable #1755 by @jzabroski in https://github.com/fluentmigrator/fluentmigrator/pull/1757

Bug Fixes

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

Copyright updates

• Update all license notices to 'Fluent Migrator Project' by @schambers in https://github.com/fluentmigrator/fluentmigrator/pull/1745

New Contributors

• @schambers made their first contribution in https://github.com/fluentmigrator/fluentmigrator/pull/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: https://github.com/fluentmigrator/fluentmigrator/compare/v5.1.0...v5.2.0

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

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<TNext>.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)