grate 1.0.0

There is a newer version of this package available.
See the version list below for details.
dotnet tool install --global grate --version 1.0.0
This package contains a .NET tool you can call from the shell/command line.
dotnet new tool-manifest # if you are setting up this repo
dotnet tool install --local grate --version 1.0.0
This package contains a .NET tool you can call from the shell/command line.
#tool dotnet:?package=grate&version=1.0.0
nuke :add-package grate --version 1.0.0

grate

grate is a SQL scripts migration runner, using plain, old SQL for migrations. No meta-language, no code, no config, no EF migrations. If 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.

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.

grate --connectionstring="Server=(localdb)\MSSQLLocalDB;Integrated Security=true;Database=grate_test"

for more configuration options, see the documentation.

grate supports the following DMBS's

  • Microsoft SQL server
  • PostgreSQL
  • MariaDB/MySQL
  • Sqlite
  • (Oracle support is in the works)

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

Product Compatible and additional computed target framework versions.
.NET net6.0 is compatible.  net6.0-android was computed.  net6.0-ios was computed.  net6.0-maccatalyst was computed.  net6.0-macos was computed.  net6.0-tvos was computed.  net6.0-windows was computed.  net7.0 was computed.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 was computed.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.

Version Downloads Last updated
1.6.2 7,434 3/13/2024
1.6.1 5,124 2/16/2024
1.5.4 28,030 9/26/2023
1.5.2 6,364 8/13/2023
1.5.1 1,924 7/23/2023
1.5.0 25,252 4/6/2023
1.4.0 22,089 9/2/2022
1.3.2 4,710 7/8/2022
1.3.1 498 7/8/2022
1.3.0 19,500 6/8/2022
1.2.0 9,022 12/17/2021
1.1.0 1,376 11/28/2021
1.0.0 442 11/22/2021
0.11.0 1,828 11/10/2021
0.10.1 370 10/20/2021
0.10.0 364 10/17/2021
0.9.6 340 10/11/2021
0.9.5 368 10/11/2021
0.9.4 329 10/7/2021
0.9.3 397 9/26/2021
0.9.2 437 9/26/2021