Create tables [AX 2012]

Updated: March 30, 2011

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

You perform the Create tables task to prepare the Microsoft Dynamics AX 2012 target database for upgrade. During this step, the Microsoft Dynamics AX 2012 database schema is created based on Application Object Tree (AOT) definitions, including tables, unique clustered indexes, default constraints, and views. (In previous releases of Microsoft Dynamics AX, the database schema was created during the synchronization step.) Other indexes and check constraints are created on tables after bulk copy but before the post-synchronization scripts run.

This task only creates the target database schema; no data is copied from the source system at this time.


Before you begin this task, use the Microsoft Dynamics AX Server Configuration Utility to confirm that the AOS statement cache is set to 40.

  1. Click Start > Administrative Tools > Microsoft Dynamics AX <version> Server Configuration Utility > Database Tuning.

  2. Locate the Statement cache field. Adjust the value if needed.

  3. Click OK.

Create the target database schema as follows:

  1. In the Data upgrade checklist, click Create tables.

    The Synchronize table form displays a progress bar that indicates the status of the operation while the upgrade framework queries the AOT and determines what tables, fields, and indexes to create in the target database. This process may take several minutes to finish.

  2. When the query process is finished, the Synchronize database form opens. Information that was collected during the previous step is displayed on four tabs. You can select items to view details about them.




    Shows what tables need to be created in the target database and summarizes the detailed results provided on the other tabs.


    Lists errors that occurred while determining what tables to create. You must fix any errors before you proceed with creating tables.


    Lists all warnings about possible data conflicts that may arise after tables are created. You should review the warnings and decide which of them require developer action.


    Lists all the tables that will be created in the target database.

    Address any errors or warnings before you continue with the data upgrade. Unresolved table errors will cause the data upgrade to fail. After you verify that there are no errors or warnings, click Continue on the Synchronize database form. The upgrade framework creates the tables in the target database.

Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).