SQL-Shoot
Database migrations & change control. PostgreSQL, SQL Server, and more (by sqlshoot)
Evolve
Database migration tool for .NET and .NET Core projects. Inspired by Flyway. (by lecaillon)
| SQL-Shoot | Evolve | |
|---|---|---|
| 1 | 5 | |
| 3 | 827 | |
| - | - | |
| 0.0 | 2.8 | |
| about 3 years ago | 29 days ago | |
| C# | C# | |
| GNU General Public License v3.0 only | MIT License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.
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.
SQL-Shoot
Posts with mentions or reviews of SQL-Shoot.
We have used some of these posts to build our list of alternatives
and similar projects.
Evolve
Posts with mentions or reviews of Evolve.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-01-26.
-
How to Handle MSSQL Database in CI/CD?
If you want to stay in C# land, look at Evolve.
-
Can I export database from PostgreSQL and connect it to my C# app?
So, in general, one would use a versioned database schema that would connect to a database and execute a series of SQL files. For C# you have things like Evolve.
-
The correct way to source control data
So you don't really source control the data, but you do source control the database schema. A common way in the .net world to do this is to use something like evolve which basically allows you to version SQL scripts and have them executed on application launch.
-
Best db migration tool options to use along with Entity Framework
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.
-
Developing with SQL Server in .NET
I've been using Evolve in the past, very simple and effective.
What are some alternatives?
When comparing SQL-Shoot and Evolve you can also consider the following projects:
monitor-table-change-with-sqltabledependency - Get SQL Server notification on record table change
Entity Framework - EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.