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

  • 7750024
  • 02-Feb-2007
  • 10-Jan-2008


How do I update the MigrationInfo table in Exchange Migrator?

Exchange Migrator 2.x

The MigrationInfo table in Exchange Migrator is not accurate.

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

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. 


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.

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

    Additional Information

    Formerly known as NETIQKB50024