6. Monitor the Progress of Table Changes

(Available for SQL Server CMSs only)

CA DataMinder provides two levels of logging for the post-upgrade changes to the Wgn3EventParticipant table:

First, each step in the overall procedure is recorded in the Wgn3JobState database table for diagnostic purposes. For example, entries are written to this table when a foreign key constraint is dropped (or re-enabled), or when the database is changed from ‘multi user’ to ‘single user’ mode.
Second, for each bcp copy operation, progress is logged in the bcp_ep_out.log and bcp_ep_in.log files for each 1,000 rows copied into or out of the table. In addition, summary data at the end of the log file shows the total time to copy all the rows and the average rate at which they were copied.