Loader tools are common in staging and testing environment where a test server needs to be created/cloned from a sample data. It is generally expected that the loader can completely overwrite the existing data in order to reset the test server to its original state. A script that simply executes “mysql < dump.sql” would be a loader tool.
- Puts external data in the database server.
- Goal is “data in”.
- Not concerned with the data once loaded.