FlubuCore
DbUp
Our great sponsors
FlubuCore | DbUp | |
---|---|---|
1 | 10 | |
893 | 2,087 | |
0.3% | 1.0% | |
5.0 | 8.5 | |
about 2 months ago | about 1 month ago | |
C# | C# | |
MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
FlubuCore
DbUp
- How to Handle MSSQL Database in CI/CD?
-
create table in SqlDataProvider
I am not super familiar with SqlDataProvider, but its generally purpose is to interact with the DB at runtime, and not to migrate sql databases. I would probably use some ddl migration tool like DbUp, https://github.com/DbUp/DbUp, to handle table creation.
- Dev ,production best way to migrate migrations
- How do you do CI/CD with ef core
-
Best db migration tool options to use along with Entity Framework
I've used a simple migration tool called DbUp https://github.com/DbUp/DbUp
- Is it sensible to run EF migrations at startup?
-
Have to use SQL Server 2005 to pull data into a web application
Yea - it usually takes some diligence to maintain sprocs in a nice way. When my teams have used dapper in a production environment/application we usually combine it with something like dbup which lets us source control all of the objects/up/down scripts. It's like EF migrations but works with simple scripts.
-
Automate Manual SQL runs
Check out DbUp This is what we use and created a custom app that gets invoked within our pipeline
What are some alternatives?
NUKE - 🏗 The AKEless Build System for C#/.NET
FluentMigrator - Fluent migrations framework for .NET
Cake - :cake: Cake (C# Make) is a cross platform build automation system.
yuniql - Free and open source schema versioning and database migration made natively with .NET/6. NEW THIS MAY 2022! v1.3.15 released!
MSBuild - The Microsoft Build Engine (MSBuild) is the build platform for .NET and Visual Studio.
roundhouse - RoundhousE is a Database Migration Utility for .NET using sql files and versioning based on source control
Albacore - Albacore is a professional quality suite of Rake tasks for building .NET or Mono based systems.
Entity Framework - EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.
CS Make - Sake Build
Evolve - Database migration tool for .NET and .NET Core projects. Inspired by Flyway.
NUKE/common
Unfold - Powershell-based deployment solution for .net web applications