Version 5.2.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

Version 5.1.0

What's Changed

Contributions

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

Dependency updates

• Bump Snowflake.Data from 2.1.3 to 2.1.5 by @dependabot in #1701

• Bump Npgsql from 8.0.0 to 8.0.1 by @dependabot in #1700

• Bump NUnit from 3.14.0 to 4.0.1 by @dependabot in #1695

• Bump FSharp.Core from 8.0.100 to 8.0.101 by @dependabot in #1713

• Bump MySqlConnector from 2.3.1 to 2.3.2 by @dependabot in #1704

• Bump MySqlConnector from 2.3.2 to 2.3.5 by @dependabot in #1720

• Bump AutoMapper from 12.0.1 to 13.0.0 by @dependabot in #1725

• Bump Oracle.ManagedDataAccess.Core from 3.21.120 to 3.21.130 by @dependabot in #1711

• Bump Oracle.ManagedDataAccess from 21.12.0 to 21.13.0 by @dependabot in #1710

New Contributors

• @lrobin136 made their first contribution in #1712
• @robert-lilleker made their first contribution in #1723

Full Changelog: v5.0.0...v5.1.0

Version 5.0.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 7f12600 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 #1580
• Limit SQLite type mappings to the 4 core data types by @mattbrailsford in #1581
• Fixes SQLite FormatIdentity bug 1456 by @mattbrailsford in #1583
• Bump MySql.Data from 8.0.11 to 8.0.28 by @dependabot in #1558
• Add missing features to SQLite runner by @mattbrailsford in #1585
• Adding additional description properties using additional list by @azerios in #1553
• Fixes #1592 by @jzabroski in #1593
• Fixes #1590 by @jzabroski in #1594
• Bump NUnit3TestAdapter from 3.17.0 to 4.2.1 by @dependabot in #1586
• Bump Shouldly from 3.0.2 to 4.0.3 by @dependabot in #1469
• Bump System.ValueTuple from 4.4.0 to 4.5.0 by @dependabot in #1467
• Bump McMaster.Extensions.CommandLineUtils from 2.3.4 to 4.0.1 by @dependabot in #1559
• Bump FSharp.Core from 4.6.2 to 6.0.3 by @dependabot in #1596
• Add support for NullsDistinct() / NullsNotDistinct() for Postgres by @lillo42 in #1603
• Move all FluentMigration.Runner code to FluentMigrator.Runner.Core by @mattbrailsford in #1600
• Make Postgres 10 & 11 processors public by @rvdginste in #1615
• Add JetBrains.Annotations.MeansImplicitUse to MigrationAttribute by @sirduke in #1620
• feat: add dotnet 6.0 support for cli tool by @johannessorheim in #1650
• Correct help for preview switch by @ToddRopog in #1658
• feat: add dotnet 7.0 support for cli tool by @PauloDaniel1993 in #1656
• Use PackageLicenseExpression by @georg-jung in #1653
• Fix a typo in a couple of error messages by @adrianbanks in #1654
• Replace MySql.Data to MySqlConnector by @lillo42 in #1678
• Add Support to MySQL 8 and add MySql extensions by @lillo42 in #1680
• Bump JetBrains.Annotations from 11.1.0 to 2023.3.0 by @dependabot in #1691
• Bump MySqlConnector from 2.2.7 to 2.3.1 by @dependabot in #1692
• Bump Snowflake.Data from 2.1.3 to 2.1.4 by @dependabot in #1697
• Bump Npgsql from 8.0.0 to 8.0.1 by @dependabot in #1696
• Bump Moq from 4.20.69 to 4.20.70 by @dependabot in #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 #1580
• @dependabot made their first contribution in #1558
• @azerios made their first contribution in #1553
• @rvdginste made their first contribution in #1615
• @sirduke made their first contribution in #1620
• @johannessorheim made their first contribution in #1650
• @ToddRopog made their first contribution in #1658
• @PauloDaniel1993 made their first contribution in #1656
• @georg-jung made their first contribution in #1653
• @adrianbanks made their first contribution in #1654

Full Changelog: v3.3.2...v5.0.0

Version 3.3.2

💯 Enhancements

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

See Also

https://github.com/fluentmigrator/fluentmigrator/milestone/34

Version 3.3.1

🐞 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

Version 3.3.0

Improvements

#1507 : Additional tool support for TFMs (@slang25 )

Version 3.2.17

Bug Fixes 🐞

#1487 : Fixes error to add default value for Json (@lillo42) (Fixes #1457 : FormatException with creating column with default json value ("{}") (@kroliczek94))

Version 3.2.16

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

Version 3.2.15

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

Version 3.2.14

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)