Strata does not ship with complex database migration tools but it does offer a simpler database import and export tool.
To generate a Migration, you should use the automated generator provided by Strata. It will ensure it will be correctly defined.
Using the command line, run the
db export from your project’s base directory.
It will generate a
.sql export of the current state of the database, named with the time is has been generated. You could check in these files to your code repository as they are stored outside of the web facing directory.
There are two methods for applying a migration. You either pass in the filename of the migration you wish to run.
You may get a
sh: mysql: command not found error if you use MAMP (or any similar platform really) and have not made the MySQL binary globally accessible.
You can do so by adding it to your export string.