Performing the Final Data Transfer

The Final Data Transfer option is disabled for a sequence until the preliminary data transfer runs without errors.

To perform the final transfer of data from the source table to the target table:

  1. In the Import Data Transfer form, select the starting and ending sequences of the tables you want to import. The sequence numbers are defined on the Import Steps form.
    Note: You can specify a range of tables. However, we strongly recommend that you transfer one table at a time.
  2. Use the On Error field to specify whether to stop or continue if an error occurs.
  3. Select Final Data Transfer.
  4. Click Process.

    Any errors that are raised here are related to business requirements, so each error should be carefully handled. If some data was missed in attempting to transfer the current table data, you must add a new mapping or create a new rule. If you see the error message Data is invalid, check for problems.

    See Troubleshooting the Data Transfer.

  5. After all errors in the final data transfer of a sequence are resolved, reset the status for that sequence in the Import Steps form to Not Started. Then rerun the preliminary data transfer and the final data transfer for the sequence.
  6. After the final data transfer completes successfully, verify that all of the data was correctly transferred into the target database. If some data did not transfer as you expected, analyze the mapping and related functions that were performed in database triggers. Determine any additional configuration or processes that must be performed to complete the migration.
  7. After all sequences have been successfully transferred and verified, perform a backup of the existing database.
Related topics