DbUp
roundhouse
Our great sponsors
DbUp | roundhouse | |
---|---|---|
10 | 5 | |
2,087 | 916 | |
1.0% | 0.0% | |
8.5 | 2.8 | |
about 1 month ago | about 2 months ago | |
C# | C# | |
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
roundhouse
-
REST API using C# .NET 7 with MySql
Before we can start using Postgres we need to create a table to store our data. I will be using excellent roundhouse database deployment system to execute database migrations.
-
Best db migration tool options to use along with Entity Framework
https://github.com/chucknorris/roundhouse is interesting, but rougher around the edges.
-
Is it sensible to run EF migrations at startup?
At my work we use https://github.com/chucknorris/roundhouse
-
Relational databases aren’t dinosaurs, they’re sharks
For our projects at work we use sqlserver and use a tool called roundhouse for migrations. https://github.com/chucknorris/roundhouse
-
Source control/release management for databases
Have a look at roundhouse too, if you have SQL experienced people this should be easy to use. All the migrations are basically sql scripts that you can version control. https://github.com/chucknorris/roundhouse
What are some alternatives?
FluentMigrator - Fluent migrations framework for .NET
Flyway - Flyway by Redgate • Database Migrations Made Easy.
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.
ASP.NET Core - ASP.NET Core is a cross-platform .NET framework for building modern cloud-based web applications on Windows, Mac, or Linux.
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
EfCore.TestSupport - Tools for helping in unit testing applications that use Entity Framework Core