DbUp
Horton
Our great sponsors
| DbUp | Horton | |
|---|---|---|
| 10 | 1 | |
| 2,083 | 18 | |
| 0.8% | - | |
| 8.5 | 10.0 | |
| about 1 month ago | over 6 years 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.
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
Horton
-
Best db migration tool options to use along with Entity Framework
I also wrote my own tool a decade ago, https://github.com/jdaigle/Horton, but I just use Flyway these days.
What are some alternatives?
FluentMigrator - Fluent migrations framework for .NET
roundhouse - RoundhousE is a Database Migration Utility for .NET using sql files and versioning based on source control
yuniql - Free and open source schema versioning and database migration made natively with .NET/6. NEW THIS MAY 2022! v1.3.15 released!
Entity Framework - EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.
Evolve - Database migration tool for .NET and .NET Core projects. Inspired by Flyway.
Unfold - Powershell-based deployment solution for .net web applications
Octo Pack - Creates Octopus-compatible NuGet packages
ASP.NET Core - ASP.NET Core is a cross-platform .NET framework for building modern cloud-based web applications on Windows, Mac, or Linux.
EfCore.TestSupport - Tools for helping in unit testing applications that use Entity Framework Core
Flyway - Flyway by Redgate • Database Migrations Made Easy.
EF-Migrations-Script-Generator-Task