Currently Working on the next version to also add better support for the VSCode Extension!
Migrondi is a SQL Migrations tool designed to be simple and execute simple migrations. Write SQL and execute SQL against your database.
No need to install it, use it from VSCode! https://github.com/AngelMunoz/migrondi-vscode
Migrondi Runs on Linux-x64, Linux-arm64, Windows-x64, and MacOS-x64 (intel based)
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.
# you can put this at the end of your ~/.bashrc
# $HOME/Apps/migrondi is a directory where you have downloaded your "Migrondi" binary
export MIGRONDI_HOME="$HOME/Apps/migrondi"
export PATH="$PATH:$MIGRONDI_HOME"you can now install this as a global/local tool as well
dotnet tool install --global Migrondi
If you are starting from scratch you can run the init command to create the migrondi files and directories needed for the rest of the commands to work properly
~/Migrondi $ ./Migrondi init
Created /home/x/Migrondi/migrondi.json and /home/x/Migrondi/migrations
~/Migrondi $
PS C:\Users\x\Migrondi> ./Migrondi.exe init
Created C:\Users\x\Migrondi\migrondi.json and C:\Users\x\Migrondi\migrations\
PS C:\Users\x\Migrondi>
Then you can adapt the configuration as needed
to use this tool you need to supply a JSON configuration file (the name must be migrondi.json)
{
"connection": "Data Source=Migrondi.db",
"migrationsDir": "./migrations/",
"driver": "sqlite"
}-
connection
This is a IDbConnection compatible connection string (you can find examples in the follwing links)
-
migrationsDir
this is an absolute or relative path to where the migrations will be stored Note: please include the trailing slash to prevent writing on the directory above of the one you pointed to. (if you use the init command, this is created for you)
-
driver
any of the following "mssql" "sqlite" "mysql" "postgres"
Migrondi 0.5.0
Copyright (C) 2020 Angel D. Munoz
init Creates basic files and directories to start using migrondi.
new Creates a new Migration file.
up Runs the migrations against the database.
down Rolls back migrations from the database.
list List the amount of migrations in the database.
help Display more information on a specific command.
version Display version information.
To create a new migration file run Migrondi.exe new -n CreateTodosTable where CreateTodosTable is the name of your migration, you can replace that name with your migration name it will create a new file with a name like this:
SampleMigration_1586550686936.sql with the following contents
-- ---------- MIGRONDI:UP:1586550686936 --------------
-- Write your Up migrations here
-- ---------- MIGRONDI:DOWN:1586550686936 --------------
-- Write how to revert the migration herePlease do not remove the MIGRONDI:UP:TIMESTAMP and MIGRONDI:DOWN:TIMESTAMP comments these are used to differentiate what to run when you run the up or down commands.
To run your migrations against your database use the "up" command Migrondi.exe up you can use -t <number> to specify how many migrations you want to run
To rollback your migrations from your database use the "down" command Migrondi.exe down you can use -t <number> to specify how many migrations you want to roll back
If you want to list migrations you can use the command "list" Migrondi.exe list with the following flag combinations
Migrondi.exe list --last trueMigrondi.exe list --all true --missing trueMigrondi.exe list --all true --missing false
these will give you these outputs
- Last migration in the database
- All migrations that are missing
- All migrations present in the database
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
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