SQL Administration (form)

  • Article

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

Click System administration > Periodic > Database > SQL administration.

Use this form to view Microsoft SQL Server tables and indexes, and to synchronize tables and indexes with changes that have been made in the Application Object Tree (AOT).

Task that uses this form

Tune data access settings

You can expand the list of tables and indexes in the tree control on the left side of the form.

The following table provides descriptions for the controls in this form.

Buttons

Button

Description

Table actions

Open a menu with the following items:

  • Synchronize database – Synchronize the schema (table and index information) from the AOT to the database. Synchronization generates the Microsoft Dynamics AX index (Axapd.aoi).

  • Check/Synchronize – Verify that the schema in the AOT matches the schema in the database, and change the database to match the AOT. Synchronization generates the Microsoft Dynamics AX index (Axapd.aoi).

  • Apply compression – Apply the table compression settings from the Table and index options form.

  • Browse table – Open the Table browser form so that you can view the fields and rows in the table.

  • Truncate – Delete all content in the table for all company accounts. Use this command with caution.

Index actions

Open a menu with the following item:

  • Reindex – Regenerate the selected index.

Generate SQL scripts

Open a menu with the following items:

  • .... for dropping tables – Generate a script that you can use to drop the selected tables from the database.

  • .... for creating tables – Generate a script that you can use to add the selected tables to the database.

Table and index options

Open the Table and index options form. Use this form to set table data compression options, and to set index data compression, fill factor, pad index, and sort in tempdb options.

Note

Data compression options are only available if you are running a version of SQL Server that supports data compression.

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