How to Move Tables to Another Layer in Dynamics AX

Tables in Microsoft Dynamics AX are identified by their application object ID number series. Different ranges of IDs are used for different application object layers. For example, IDs in the range 1-20000 are used for SYS layer objects, whereas objects in the VAR layer use IDs in the range 30001-40000. This is important if you want to move tables and the data in the tables from one layer to another, for example, from the VAR to the CUS layer. This procedure describes how to move a table, together with data, to another layer.

Procedures

To move a table to another layer

1. Start Microsoft Dynamics AX in the application object layer that the source tables are located in.

2. Export the data from the tables that you want to move. For more information, see How to: Export Objects from a Selected Layer.

   Note

   Select Field type Binary in the Export options dialog box to preserve container fields and increase performance.

3. Export the tables that you want to move to an .xpo file. For more information, see How to: Export Application Objects.

4. In the Application Object Tree (AOT), delete the tables that you want to move.

5. Exit Microsoft Dynamics AX.

6. Restart Microsoft Dynamics AX in the layer that you want to move the tables to.

7. Import the tables from the .xpo file that you created in step 3. For more information, see How to: Import Application Objects.

8. In the AOT, right-click the Data Dictionary node, and then click Synchronize to synchronize the database with the imported tables.

9. Import the data from the location that you exported the data to in step 2. For more information, see How to: Add Data. The data is added to the tables with the new application object IDs allocated for the destination layer.