This repo shows some ideas, how to use the evolve-db tool for managing changes in databases.
- https://evolve-db.netlify.app/
- https://evolve-db.netlify.app/concepts/
- https://evolve-db.netlify.app/getting-started/tool/
The create-db scripts are set up for MSSQL 2019.
To create a new DB, create a corresponding SQL script in the sql-master directory and use the args-master.txt.
It cereates databases. It modifies the master database, so it creates migration table in it, showing that changes
on the database server level can be then tracked too.
If you do not want to use database changes tracking in the master database, execute script(s) from the sql-master
directory manually.
Start with creating a new DB:
./evolve.exe info @args-master.txt
./evolve.exe migrate @args-master.txt
The TestDB database migrations are done by:
./evolve.exe info @args-TestDB.txt
./evolve.exe migrate @args-TestDB.txt
The Monitor database migrations are done by:
./evolve.exe info @args-Monitor.txt
./evolve.exe migrate @args-Monitor.txt