Chapter 6
Data Refresh, Backup, and Restore
Data Refresh—Manual, ETL, and Script
A typical corporate IT environment usually has three different environments—namely development, test, and the production. A development environment is what the coders and database administrator (DBA) use as the playing field for development of their application or database (DB). Tests will be conducted later on a test environment, and if everything works well, the final product will go to the production environment on a demilitarized zone that faces the Internet and the public end users.
Note that when we have separate environments, large databases are usually hosted on different servers that are usually dedicated to hosting the databases; applications are on a ...
Get Database and Application Security: A Practitioner's Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
