What is the Loader Utility

The Loader utility is a command line tool that facilitates the import of large amounts of data from a file into a table of a Relational Database Server database.

The utility is useful for activities such as periodic batch updating of the database from information derived from other databases or for migrating data extracted from some other database.

The utility enables you to describe the form of the input data and to establish various filtering and mapping rules for cases where the input data does not precisely reflect the table in the target database. You can also indicate that only portions of the data from the file be loaded into the table.