Create tables

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, 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.

Important

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.

    Tab

    Description

    Overview

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

    Errors

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

    Warnings

    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.

    Info

    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.