Thursday 26 November 2015

Preserve legacy Id while AX 2012 upgrade

Preserve legacy element IDs is one of the step in code upgrade checklist in place

this workout is only in the case mention below.

When the environment have separate AOS and SQL (Database) Servers then it’s complex to handle Preserve legacy Id. it tricky to handle

Go through the trick below:

When you are ready to perform the Preserve legacy element IDs task, stop the target system AOS

  • Create or identify a temporary file share on the SQL server. And assign rights to “Network service” or the user with AOS service is running
  • Copy the file SysUpgradeExportIdMap.csv to the file share on the SQL server on the above created folder
  • Retrieve the file DatabaseUpgrade\XPO\MicrosoftElementsRenamed62.csv from the installation media, and copy it to the same location on the SQL server
  • Open a Microsoft Dynamics AX 2012 Management Shell window, and execute the following command
  • While running the below command it will generate IdDataFormat.xml and RenameDataFormat.xml on the path c:\. Copy both file and paste to SQL server on the same path “c:\”
  • Run the command on “c:\” not to c:\windows\system32
axutil idkeep /idfile:\\TEST-DB\ElementIdLegacyid\SysUpgradeExportIdMap.csv /renamefile:\\TEST-DB\ElementIdLegacyid\MicrosoftElementsRenamed62.csv /verbose

(:\\TEST-DB\ElementIdLegacyid\) is the shared path on DB server



This helped you..!! Then hit the ads on the page..:)

3 comments:

  1. Hi, i had some issues with legacy id's during my mock 2012 --> 2012R3 CU8 slipstream migration... for testing purposes, AOS and Db were on the same server.
    I can remember ever having those two files that you have mentioned - "...While running the below command it will generate IdDataFormat.xml and RenameDataFormat.xml on the path c:\..."
    other two .csv files are generally mentioned in the documentation and i have been used those.
    Was there something i was missing?
    thanks,

    ReplyDelete
  2. Great help, I have spend around 1 week and this post really help me to resolve my issue. :)

    ReplyDelete