EDT Relation Migration Tool [AX 2012]


Updated: May 18, 2011
Applies To: Microsoft Dynamics AX 2012 R2, Microsoft Dynamics AX 2012 Feature Pack, Microsoft Dynamics AX 2012
In Microsoft Dynamics AX 2012, relations can no longer be created under extended data type (EDT) nodes in the Application Object Tree (AOT). Relations that are defined under EDT nodes are still effective, but in a future release they will be obsolete and deleted. The EDT relation migration tool helps you move relations from EDT nodes to table nodes. The EDT relation migration tool is found on the client menu, under Tools > Code upgrade > EDT relation migration tool.
Before Microsoft Dynamics AX 2012, relations could be defined under the Relations node of an EDT node, or under a table node.
The following table describes the differences between how relations were handled in Microsoft Dynamics AX 2009 and how relations are handled in Microsoft Dynamics AX 2012.
Microsoft Dynamics AX 2009
Microsoft Dynamics AX 2012
Both table and EDT relations were supported. EDT relations could not contain metadata such as cardinality and relation type.
New EDT relations cannot be created. Use table relations instead. Table relations can contain metadata.
Table relations could not be used for dynamic links.
Table relations now support dynamic links.
Table relations could not be used for unbound control lookup.
Table relations now support unbound control lookup.
Having both types of relations on a single table could introduce ordering problems in certain circumstances.
New EDT relations cannot be created. We recommend that you convert all existing EDT relations to table relations. To preserve existing behavior, a new property that is named Reference Table has been added to the EDT structure. Each EDT node in the AOT contains a new Table References node that stores lookup information.
When you first start the EDT relation migration tool, a message may be displayed: The data on existing EDT relations needs to be refreshed. Do you want to continue?Click Yes to refresh the list of EDT relations.
You can use the EDT relation migration tool to help you complete the migration process. The tool can perform the following actions:
  • Copy EDT relations to all referencing tables.
  • Add relation metadata under the table nodes.
    • Derive the cardinality from the index on the foreign key.
    • Derive the relationship type from the delete action or key composition.
    • Determine the role names.
  • Generate a report of the data artifacts that are affected by the migration, for all given relations. The affected artifacts can include the following:
    • Queries
    • Forms
    • Delete actions on tables
    • Data sets
    • X++ reports
For examples of specific operations and typical migration scenarios, see the Migrating EDT Relations white paper.
The following figure displays the EDT relation migration tool.
EDT relation migration tool
The EDT relation migration tool, displaying the EDT relations for the WrkCtrTable
The left pane displays a list of tables that contain EDT relations. When you select a table in the left pane, the right pane displays the metadata of the selected table that may be affected by the migration.
The following items describe how to navigate the form:
  1. The left pane contains the Table name list, which displays all the tables that contain EDT relations.
  2. Select a table in the Table name list. A list of EDT relations that are used by that table is displayed on the EDT Relations FastTab in the pane on the right side.
  3. Select an EDT relation on the EDT relations FastTab. Details of that EDT relation are displayed on the FastTabs under the EDT relations section.
  4. If the Migration status field for an EDT relation is set to Not migrated, you can select the migration action in the Migration action field.
The following tables provide descriptions for the controls in this form.

Left Side Pane

List
Description
Table name
The tables that use EDT relations.

Right Side Pane

FastTab
Description
EDT relations
View the list of EDT relations that are used by the selected table.
Relation properties
View the properties of the selected EDT relation.
Affected delete action
View whether the EDT relation is used in a delete action of the table.
Affected forms
View the forms that are affected by this relation.
Affected queries
View the queries that are affected by this relation.
Affected data sets
View the data sets that are affected by this relation.
Affected X++ reports
View the X++ reports that are affected by this relation.

Menu Actions

Action
Description
Refresh relation data
Refresh the relation data.
Scan test artifacts
Scan the test artifacts.
Migrate multiple tables
Migrate the selected tables. More than one table must be selected. Otherwise, this action is not available.
Migrate single table
Migrate the selected table. Only one table can be selected. Otherwise, this action is not available.

Buttons

Button
Description
Migrate all
Set the Migration action field to Migrate for every relation for which the Migration status field is set to Not migrated.

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.