Migrate is a tool for performing declarative migrations by finding differences between a declared and desired database schema, and the existing one, currently in a SQLite database. It can be used from the command line or as a library.
If you just want to test the tool without installing .Net, then you can use a Docker image:
docker run -it 'mcr.microsoft.com/dotnet/nightly/sdk:8.0' bashInside the container run:
export PATH="$PATH:/root/.dotnet/tools"After having .Net in your system you can run
dotnet tool install --global migtoolmkdir my_database_project
cd my_database_project
mig init
# generated project files with example definitions
mig status
# output shows migration for existing definitions
mig commit
# executes migration
mig log -s
# output shows migration metadata and a summary of executed stepsSee usage
See motivation