Knexfile

Migrations

Migrations are a best practise for SQL databases to roll out and undo changes to the data model and are set up automatically with an SQL database connection. The generated knexfile.ts imports the app object to establish the connection to the database. To run migration scripts for the connection from the configuration environment use:

npm run migrate

To create a new migration, run

npm run migrate:make -- <name>

and replace <name> with the name of the migration you want to create. This will create a new file in the migrations/ folder.

tip

For more information on what is available in migration files, see the Knex migrations documentation.