Restructure database schema for inherited tables

  • Article

Important

This content is archived and is not being updated. For the latest documentation, see Microsoft Dynamics 365 product documentation. For the latest release plans, see Dynamics 365 and Microsoft Power Platform release plans.

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2

After Microsoft Dynamics AX 2012 R2 or R3 data upgrade has been completed, the Restructure database schema for inherited tables task flattens the database schema inherited from the source system. The resulting simplified table hierarchy is intended to improve performance by speeding data retrieval.

Perform the following steps to complete this task.

  1. In the Data upgrade checklist or the Data upgrade checklist for in-place upgrade, click the Restructure database schema for inherited tables task. The task generates a SQL query that is saved as <drive>:\Users\<username>\AppData\Local\Temp\1\AX2012FlatteningDB.sql.

  2. Shut down the AOS.

  3. Open the file AX2012FlatteningDB.sql and copy its contents into a query window in SQL Server Management Studio.

  4. Run the query.

  5. Start the AOS.

  6. Synchronize the database.

  7. Mark the checklist task as complete.