How do I update the MigrationInfo table in Exchange Migrator? (NETIQKB50024)

goal
How do I update the MigrationInfo table in Exchange Migrator?

fact
Exchange Migrator 2.x

symptom
The MigrationInfo table in Exchange Migrator is not accurate.

symptom
MigrationInfo table in the EMA database is reporting incorrect paths for migrated objects

cause
If Exchange Migrator migrates an object, and that object gets moved to a different OU afterwards, path information in the MigrationInfo table will be incorrect.  Any subsequent synchronization or re-migration attempts will fail because it will not be able to find the object. 

fix

Use the SQL Query Analyzer or OSQL commands to make changes to the table. 

To change the table using SQL Query Analyzer:

1. In SQL Enterprise Manager, click Tools> SQL Query Analyzer.
2. Select the EMA database.
3. Execute the following query:

Update MigrationInfo
Set targetcontainer = '<desired path>'
where idobject = <desired IDObject Number>

To change the table using OSQL:

1. Click Start > Run.
2. Enter cmd.
3. Start OSQL client by entering osql -U sa <SQLServerlogin>.
4. Enter password.
5. Select the EM database by entering use EMA.
6. Enter go.
7. Update the MigrationInfo table as needed by entering the following statement: 
   
   Update MigrationInfo
Set targetcontainer = '<desired path>' 
Where idobject = <desired IDObject Number>



8. Enter go.

note
Use caution when changing the contents fo the table. An error could cause data corruption.

Formerly known as NETIQKB50024