Upgrade from AX 2012 - Plan by using the Upgrade analysis report


Upgrade is currently only supported from either Dynamics AX 2012 R2 or Dynamics AX 2012 R3. For each release, please update to the latest available cumulative update before upgrading to latest finance and operations application release.

This article explains how to use the Upgrade analysis report to plan your upgrade from Microsoft Dynamics AX 2012. The report script is run against an AX 2012 database and parses tables for application setup and data volumes. It provides feedback about deprecated features, application settings, database settings, and table space savings.

Space saving observations provide cleanup routines in AX 2012 to help reduce the subscription cost for finance and operations apps. SQL configuration optimization suggestions can help speed up the upgrade processes. Additionally, the report warns if any AX 2012 features are obsolete in the current version. Therefore, you can plan ways to replace or work around those features.

Download the report script

To download the Upgrade analysis report script (UpgradeAnalysisReport.SQL), go to Upgrade Analysis Report.

Run the report script

  1. Open SQL Server Management Studio.

  2. Open the Upgrade analysis report script (UpgradeAnalysisReport.SQL) in a new query window.

  3. Change the database connection to your AX 2012 business data database (for example, MicrosoftDynamicsAX).


    The script requires the model store database to cross-check against object data. However, the script isn't directly run against the model store.

  4. Run the script.

  5. Save the results, or copy them and paste them into a workbook.