August 2017
Intermediate to advanced
332 pages
9h 16m
English
Database schema migration is a process of incremental changes to the relational database structure. Let's have a look at the following diagram to understand it better:

The database in the version v1 has the schema defined by the V1_init.sql file. Additionally, it stores the metadata related to the migration process, for example, its current schema version and the migration changelog. When we want to update the schema, we provide the changes in the form of a SQL file, such as V2_add_table.sql. Then, we need to run the migration tool that executes the given SQL file on the database (it also updates the metatables). ...
Read now
Unlock full access