Bulk loading is used when you need to import or export large amounts of data relatively quickly.

Run Bulk Loads: Starts the Bulk Load Utility that performs a mass-record copy of the entire source database over to the DataServer target. You can also choose to bulk load only a few select tables based on the number of records they contain. For example, to begin with, you may want to bulk load only those tables that have over 100,000 records. Or, alternatively, you may want to bulk load only those tables that have less than 100,000 records. You can accomplish this by performing a database or table analysis using the DBANALYS or TABANALYS command in proutil and then using the output to create filters in the Bulk Load Utility.

Enter the appropriate information to begin a mass-record copy of source side table data to the appropriate target side table structure. The Run button begins the Bulk-load process.

Bulk Load Running Status: Displays the real-time status of the ongoing bulk load process. Granular data, such as the count of tables successfully processed, left to process, or failed during the bulk load process, is displayed along with the global status of the bulk load process on the bulk load status card. The information on the bulk load status cards is automatically updated every five seconds.

Bulk Load Report: Generates a Bulk Load report after the Run Bulk Loads command is executed. You can generate the report by clicking Proceed. This displays the Bulk-load report on the screen. You can also choose to export the report to PDF or Excel.

For more information about the bulk load process, see Bulk load with Pro2 .