Database Maintenance
Over time, a database need maintenance.
This are administrative tasks that keep a database healthy and functional.
In case of power failure or natural desasters a database can break or stop working.
In this case we need to repair the database back into production.
Maintenance Tasks
- Install: run database creation and schema build;
- Secure: create roles, urser and grand access;
- Evolve: run evolution scripts to update schema;
- Load: add initial or previously extracted data;
- Extract: export data into data files;
- Transform: modify data structure;
- Replicate: transfer data to a remote database;
- Backup: save data and database structure;
- Restore: import data and structure from a backup.