DbUp
yuniql
Our great sponsors
DbUp | yuniql | |
---|---|---|
10 | 11 | |
2,083 | 409 | |
0.8% | - | |
8.5 | 0.0 | |
about 1 month ago | 6 months ago | |
C# | C# | |
MIT License | Apache License 2.0 |
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
yuniql
-
yuniql: A cross-platform, multi-database schema version control made with C#/.NET6
Here's one that with the hotfix. https://github.com/rdagumampan/yuniql/releases/download/v1.3.15/yuniql-cli-win-x64-v1.3.15.zip
- yuniql: Cross-platform, multi-database schema version control. Zero dependencies. Plain SQL. Just release v1.30!
-
Released yuniql v1.2.25. Multi-tenant support, Oracle and largest set of bug fixes
Announcing release of yuniql v1.2.25. yuniql is a database version control and migration tool. Absolute zero runtime dependencies and use plain sql script files.
- GitHub - rdagumampan/yuniql: Painless database schema version control. Built from experience. RawSql -> Connect -> Apply -> Erase -> Destroy - Repeat.
- GitHub - rdagumampan/yuniql: Painless database version control. Built from experience.
-
Monthly 'Shameless Self Promotion' thread - 2022/01
yuniql is free and open source tool for repeatable database deployment and schema version control. No runtime dependencies, just single exe/tar file. Write SQL just as you are used to. Keep them in folders just as you are used to. Supports wide range of databases.
- Mayroon bang mga killalang pilipino na open source na project?
- Project #yuniql: Painless database schema versioning engine made natively with .NET Core. Plain SQL, cross-platform, zero runtime dependencies ;)
What are some alternatives?
FluentMigrator - Fluent migrations framework for .NET
Octo Pack - Creates Octopus-compatible NuGet packages
roundhouse - RoundhousE is a Database Migration Utility for .NET using sql files and versioning based on source control
liquibase - Main Liquibase Source
Entity Framework - EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.
Flyway - Flyway by Redgate • Database Migrations Made Easy.
Evolve - Database migration tool for .NET and .NET Core projects. Inspired by Flyway.
Unfold - Powershell-based deployment solution for .net web applications
monitor-table-change-with-sqltabledependency - Get SQL Server notification on record table change
RepoDb - A hybrid ORM library for .NET.