Skip to main content

Notifications

Microsoft Dynamics AX (Archived)

How to change relations on extended data types imported from AX 2009 to table references?

Posted on by Microsoft Employee

I have some extended data types imported from AX 2009 to AX 2012. (They was created by someone else than me and imported by someone else.) They have relations on them but it should be ok because they are related to 1 table. They can be recreated in AX 2012 way using table reference.

But there are some problems in my way to recreate them in AX 2012 way.
1) The table relation can not be set. (Probably because there is relation on EDT).
2) I can not find how to delete whole relation group.
3) When I try to delete relation from relation group my AX client stop working.

Is there some way how to recreate EDT migrated from AX 2009 to AX 2012. (I want to keep the names due to the existence EDT on tables, return types in methods etc.)

I try to use EDT migration tool but it tells me that I will need to migrate the EDT manually (or skip migration at all).

Could anyone give me some trick how to migrate relations on EDT (related to single table) to the table references with keep of the EDT on tables, return types in methods etc. (Without destroying tables etc.)?

(Some trick with import/export.)

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to change relations on extended data types imported from AX 2009 to table references?

    At the end I created them all again, export tables to .xpo and replace old ones by new ones.

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: How to change relations on extended data types imported from AX 2009 to table references?

    Hi,

    There is one "dirty" trick (but I wouldn't recommend turning it into a practice) :

    1. Export the EDT to XPO file. Make a backup of the XPO
    2. Open XPO in text editor and delete all text between the following tags:
    TYPEREFERENCES
    ..
    ENDTYPEREFERENCES
    1. Import the XPO back
    2. Synchronize AOT

  • Suggested answer
    Bashir Ahmad Profile Picture
    Bashir Ahmad 5,248 on at
    RE: How to change relations on extended data types imported from AX 2009 to table references?

    This may Help:

    msdn.microsoft.com/.../bb315018.aspx

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,134 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,928 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans