FluentMigrator vs SchemaHero
FluentMigrator
fluentmigrator.github.ioSchemaHero
schemahero.ioSide by side
| Figure | FluentMigrator | SchemaHero |
|---|---|---|
| Price from | Free | — |
| Free plan | Yes | — |
| Free trial | — | — |
| Open source | — | — |
| Web | — | Yes |
| Windows | Yes | Yes |
| macOS | Yes | Yes |
| Linux | Yes | Yes |
| Self-hosted | Yes | Yes |
| Plans published | 1 | 0 |
| Spec score · Database Migration Tools | 8.2 (#10) | 7.4 (#24) |
| CI/CD | The dotnet-fm documentation includes a GitHub Actions example for building an application and running migrations. | SchemaHero documents GitHub Actions and GitLab CI workflows for planning and applying schema changes. |
| Database support | The documentation lists providers including SQL Server, PostgreSQL, MySQL, SQLite, Oracle, Firebird, IBM DB2, SAP HANA, Snowflake, and Redshift. | Supported database engines listed by SchemaHero are PostgreSQL, MySQL, CockroachDB, TimescaleDB, Cassandra, SQLite and RQLite. |
| License | The project is released under the Apache-2.0 License. | The GitHub repository is licensed under Apache-2.0. |
| Purpose | FluentMigrator is a .NET framework for managing database schema changes through version-controlled C# migrations. | SchemaHero is an open-source database schema migration tool that converts schema definitions into migration scripts. |
| Support | The project points users to GitHub Discussions, bug reports and feature requests, and the fluent-migrator Stack Overflow tag. | The project directs users to a Replicated Community forum and the #schemahero channel in Kubernetes Slack. |
Plans
In their own words
FluentMigrator
FluentMigrator is a free .NET framework for managing database schema changes with version-controlled C# migrations. Its fluent C# API defines Up and Down methods for applying changes and rolling them back. The project lists providers for SQL Server, PostgreSQL, MySQL, SQLite, and Oracle, among others; provider packages are selected separately. Migrations can run inside an application, with the Migrate.exe console tool, or through dotnet-fm, which integrates with the cross-platform .NET CLI. By default, FluentMigrator creates a VersionInfo table to record completed migrations. Command-line runners can preview generated SQL without executing it, and the CLI can validate migrations before execution. The project documents .NET dependency injection integration and CI/CD examples for GitHub Actions, Azure DevOps, and Jenkins. The Quick Start calls for .NET 8.0 or later, a supported database, and basic C# and database knowledge. FluentMigrator is released under the Apache-2.0 License, with releases distributed through NuGet.
SchemaHero
SchemaHero has no write-up on Specifiction yet; its figures are above.