Dynamics AX 2009 Database Diagram

1
votes

i'm desperately searching for dynamics ax 2009 database diagram. Does anyone have it ?

Thank you

3
dynamics-ax-2009
Been looking for that for a year myself. I wish the tables used foreign keys. That would make my life so much easier. - Brent Lamborn

3 Answers

-1
votes

Me too. Let us know if you find anything because I don't think it exists... In the meanwhile try this unfinished AX40datamodel.doc document to kick-start your knowledge.

8
votes

For a list of tables in AX 2009 see the MSDN documentation Dynamics AX 2009 Tables

To create a Visio UML Data Model diagram, place the tables you want to include in a project and use the Reverse Engineering Tool

0
votes

With more than 2000 tables it would be a huge diagram. If you look at the tables in the AOT most of them have relations set on them You can also use the Cross-Reference Select the table / table field you are interested in knowing more about. Right click / Add-Ins / Cross-Reference / Used by Here you will get a complete list of everywhere the selected object is used

The Cross reference must be updated ofcourse - prior to this. It can be a long process - most the time it is only updated in Development and Test environments

You do that by clicking the main AOT node. Right click here and do like mentioned above. But select 'Update' instead of 'Used By'. It may take hours