Creating a Delete Migration

Use these steps to create the outbound migration for the delete migration.

Note: You can only specify tables for a delete migration.
  1. In your source environment/instance of WFM, select Maintenance > System Administration > Data Migration > Migration Export > Create Outbound Migration.
  2. On the Basic Information screen of the wizard, specify this information:
    Name
    Specify the name of the outbound migration. This field is required.
    Description
    Specify a description.
    Delete Migration
    Select the Delete Migration check box to create a Delete Migration.
  3. Click Next to display the Select Objects screen of the wizard.

    From this screen, you have these options:

    • The '+' icon allows you add objects to your migration.
    • The garbage can icon allows you to remove objects from your migration.
  4. Click the '+' icon to add an object to the migration by opening the Select Tables dialog.

    From this dialog, you can:

    • Multi-select or select all objects for the current page. You cannot multi-select for all pages in the dialog.
    • Search for object types using the Name column.
    • Sort the object types using the column headings.
  5. After selecting the tables you want to include in your delete migration, you have these options:
    • +Add: Add the object to your migration and continue selecting other objects for your delete migration.
    • +Add and Close: Stop adding additional objects to your delete migration.
    • x Close: Stop adding objects to your delete migration.

    The selected tables appear as tabs on the screen that you can select.

    Note: These tables contain all the records from the database. You cannot select individual records as part of a delete migration.
  6. After selecting the tables that are part of your delete migration, click Next to proceed to the Review screen of the wizard. This screen is a summary of your delete migration.

    The Review screen of the wizard lists the tables that you have selected for the delete migration. On this screen, you can:

    • Review the name and description of your outbound migration.
    • Click Download to download an XML file to check the contents of the migration to verify the data being migrated is correct.
      Note: By default, the download option is hidden. Administrators must enable this option for specific security groups that are allowed to download the data.

      To enable this option, edit the Maintenance Form for Create Outbound Migration. Specify the appropriate permission for the DMW_DOWNLOAD element for the specific security group.

  7. Once you are satisfied with the contents of your delete migration, click Confirm.
  8. The delete migration now appears in the Maintenance > System Administration > Data Migration > Migration Export > Outbound Migration screen.

    This screen contains this information:

    Name
    Name of the outbound migration.
    Description
    Description of the outbound migration.
    Create User
    User that created the outbound migration.
    Actual User
    Name of the actual user who created the outbound migration. The actual user would be different from the user in the case of a proxy.
    Create Time
    Time at which the outbound migration was created.
    Export Status
    Export status of the outbound migration. Y if the migration has been exported; N if it has never been exported.

    Once the migration is created it cannot be edited. If you want to change the migration in any way, you will need to create a new one.

    Note: You also have the option of creating a new outbound migration on this screen by clicking the Create new migration button.
  9. If you are ready to export the outbound migration to your target environment of WFM, click Export to open the Export Migration dialog.

    Specify this information:

    Destination Environment
    Select the target environment or environments of WFM that you configured in Step 1: Configuring the migration environment.
    Note: You can select more than one environment for your export. Use this option to make your export file available to import on multiple environments.
    Purpose
    Specify a short description of the export action.
  10. Click Export again to finalize the migration export.
The delete migration file is encrypted and sent via SFTP to the destination/target environment as a data migration file (*.enc format). A Job Scheduler task named Send Migration Task is automatically triggered as part of the export. The user that triggered the migration also receives a Workmail that the migration export is finished along with some details of the migration.