Saturday, August 9, 2014

AX 2012 - Database entity relationship diagrams

Hi Friends,

The database diagram is very useful to find the relationship between the tables and it helps to understand the flow. So, mostly i prefer to find the diagrams in the SQL server, but in AX there is no option to create diagram in development workspace.

Microsoft lunched the AX database relationship website it helps to understand the tables relationship.

Please have a look on this website http://www.microsoft.com/dynamics/ax/erd/ax2012r2/Default.htm


The below screenshots explains what are the tables related with vendor transactions.


ERD, centered on 'VendTrans'.

Thanks,
Hari

1 comment :

  1. An Entity Relationship Diagram (ERD) is a visual representation of different entities within a system and how they relate to each other. Entity relationship diagrams are used in software engineering during the planning stages of the software project. They help to identify different system elements and their relationships with each other. It is often used as the basis for data flow diagrams or DFD’s as they are commonly known. You an visualize ER diagrams using a ER Diagram Tool

    ReplyDelete