Migrondi

Migrondi is a SQL Migrations tool designed to be simple and execute simple migrations. Write SQL and execute SQL against your database.

Migrondi Runs on the major three platforms on both x64 and arm64.

Install

For .NET users

Grab it as a dotnet tool

dotnet tool install Migrondi

For Non .NET users

Grab the binary from the releases page or build from source and put it on your PATH, that way the command is available globally e.g.

Alternatively, you can use the following one-liners to install the latest version:

Linux/OSX

curl -fsSL https://raw.githubusercontent.com/AngelMunoz/Migrondi/vnext/migrondi_install.sh | bash

This will download and execute the migrondi_install.sh script. It will install migrondi to $HOME/.local/share/Migrondi by default and attempt to add it to your shell's PATH.

If you prefer manual installation:

# you can put this at the end of your ~/.bashrc or ~/.zshrc
# $HOME/Apps/migrondi is a directory where you have downloaded your "Migrondi" binary
export MIGRONDI_HOME="$HOME/Apps/migrondi"
export PATH="$PATH:$MIGRONDI_HOME"

Windows users

Open PowerShell and run:

iwr https://raw.githubusercontent.com/AngelMunoz/Migrondi/vnext/migrondi_install.ps1 -UseBasicParsing | iex

This will download and execute the migrondi_install.ps1 script. It will install migrondi to $env:LOCALAPPDATA\\Migrondi by default and attempt to add it to your user PATH.

If you prefer manual installation:

# you can put this at the end of your $profile file
$env:MIGRONDI_HOME="$HOME/Apps/migrondi"
$env:PATH += ";$env:MIGRONDI_HOME"

or add it via the System Properties

• Open the Start Search, type in "SystemPropertiesAdvanced.exe",
• Click the “Environment Variables…” button.
• Edit the PATH env variable and add the location of the migrondi executable.
• You might need to restart your machine for the changes to take effect.

Quick Usage Reference

Description:
  A dead simple SQL migrations runner, apply or rollback migrations at your ease
Usage:
Migrondi [command] [options]
Options:
--version       Show version information
-?, -h, --help  Show help and usage information
Commands:
init, setup <path>         Creates a migrondi.json file where the comand is invoked or the path provided []
create, new <name>         This will create a new SQL migration file in the configured directory for migrations
apply, up <amount>         Runs migrations against the configured database []
down, rollback <amount>    Runs migrations against the configured database []
list, show                 Reads migrations files and the database to show what is the current state of the migrations
show-state, status <name>  Checks whether the migration file has been applied or not to the database

Build

Use the build.fsx (dotnet fsi build.fsx) script or clone and run

dotnet publish -c Release -r <RID> --self-contained true -p:PublishSingleFile=true -o dist

replace RID and the angle brackets with any of the following

• Windows RIDs
• Linux RIDs
• MacOS RIDs

this should give you a binary file in the dist directory, after that put it wherever you want and add it to your path and you can start using it