How do I update Exchange Migrator with a changed target account name or path? (NETIQKB18908)

goal
How do I update Exchange Migrator with a changed target account name or path?

fact
Exchange Migrator 1.1

fact
Exchange Migrator 2.x

fix

If a target account name changes or moves, then the Exchange Migrator EMA database will need to be updated with the new name and/or location in order for synchronization and DL membership updates to work correctly. If the DMA Mappings are also being used, the DMAMappings table will also need to be manually updated. Re-importing of a corrected Protar will not update the existing entry in the DMAMappings table.

To update an EMA database table:

1. Open SQL Enterprise Manager.
   
2. Connect to the EM Server.
   
3. Open the EMA database.
   
4. Select the 'DMAMappings' table and Return All Rows.
   
    or
   
   Select the 'MigrationInfo' table and Return All Rows.
   
5. Update the appropriate accounts path and/or name.

**NOTE** The number of characters allowed for the fields is a preset number. Be sure to account for the number of characters you add to the account name or path. If you are only removing characters and the end result will be an entry that is shorter (less characters) than the original, this will not be a problem.  After you add characters, go to the end of the line and delete the same number of blank spaces as the number of characters you entered. Otherwise SQL will not allow you to update that particular field.

e.g. You change CN=UserName to CN=Lastname\, Firstname - CN=UserName is 11 characters whereas CN=Lastname\, Firstname is 23 characters. In this case you would scroll to the end of the line past the dc=com and delete 12 spaces.

Formerly known as NETIQKB18908