grate.core 1.7.4

grate

grate is a SQL scripts migration runner, using plain, old SQL for migrations. No meta-language, no code, no config, no EF migrations. It gives you full flexibility, and full control of your migrations, and lets you use all the fancy features of you particular database system. You are not constrained to any lowest common feature set of all supported databases.

grate.core

This is the core package, which does nothing by itself. You need to add a database specific package to use it. See below for the list of supported databases.

grate (dotnet tool)

grate is also available as a dotnet tool, which can be installed with the following command:

dotnet tool install -g grate

Minimal example

The only required argument to pass to grate is a connection string to tell it where to find your database. It will deploy to that database, looking for sql scripts in the current directory.

[Fact]
public async Task Run_migration_agains_target_db()
{
    var serviceCollection = new ServiceCollection();
    serviceCollection.AddLogging();
    serviceCollection.AddGrate(builder =>
    {
        builder
            .WithSqlFilesDirectory("/db")
            .WithConnectionString("mariadb/mysql connection string here")
    })
    .UseMariaDb(); // Important!, you need to specify the database type to use.
    var serviceProvider = serviceCollection.BuildServiceProvider();
    var grateMigrator = serviceProvider.GetRequiredService<IGrateMigrator>();
    await grateMigrator.Migrate();
}

for more configuration options, see the documentation.

grate supports the following DMBS's

Database	NuGet package
Microsoft SQL server (sqlserver)
PostgreSQL (postgresql)
MariaDB/MySQL (mariadb)
Sqlite (sqlite)
Oracle (oracle)

Full documentation can be found at https://erikbra.github.io/grate/.