Our great sponsors
-
roundhouse
RoundhousE is a Database Migration Utility for .NET using sql files and versioning based on source control
-
WorkOS
The modern identity platform for B2B SaaS. The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning.
-
DbUp
DbUp is a .NET library that helps you to deploy changes to SQL Server databases. It tracks which SQL scripts have been run already, and runs the change scripts that are needed to get your database up to date.
-
Entity Framework
EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.
-
InfluxDB
Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.
https://github.com/chucknorris/roundhouse is interesting, but rougher around the edges.
I also wrote my own tool a decade ago, https://github.com/jdaigle/Horton, but I just use Flyway these days.
I've used a simple migration tool called DbUp https://github.com/DbUp/DbUp
Been using https://github.com/lecaillon/Evolve for many years. Its a .Net Core equivalent to Flyway. You run plain old SQL scripts and just follow a file naming convention. It can run embedded inside a project, it has a .Net Tool and a standalone CLI. The SQL scripts can also be embedded in the executable or as external files.
Related posts
- Multi-tenancy using schemas with Entity Framework and PostgreSQL
- Linux or Windows for .net development?
- Show HN: Tankman – An Open Source User Management and Authorization MicroService
- EF Core/NET 6 - How to execute sql server stored procedure and get the result set?
- Deploying sqlite database to android emulator