Tuesday, October 9, 2012

Database Model Diagrams in Axapta

I am going to explain how to easily get Database Model Diagrams for set of tables you wish to in Axapta.
Here are the steps to do:
  1. Create a new Shared project.
  2. Drag all the tables you need for the datamodel diagram in to your project.
  3. Click Tools > Reverse Engineer. The Reverse Engineering dialog box displays
  4. In the dialog box, select ERX ER Data Model.
  5. Select the project you just created
  6. In the file name give correct path of windows location where you wish to create the .erx file.
  7. Click OK.
  8. Now go to Microsoft Visio
  9. Click File > New > Software and Database (or Database if you are using Microsoft Office Visio 2003) > Database Model Diagram
  10. On the Database menu, point to Import, and then click Import Erwin ERX file.
  11. In the dialog box, click the Browse button, navigate to the location of the .erx file that you generated from the Reverse Engineering tool, select the file, and then click OK.
  12. You will now see that tables you selected appear in Tables and Views window.
  13. Drag items from the Table and Views window onto the diagram surface. After you have added a table to the diagram, you can right-click the table in the diagram, and then click Show Related Tables. This will add all the related tables from the Tables and Views window that are not already in the diagram
You can then modify the diagram as you wish for the ease of understanding like you can delete the unecessary fields.

1 comment:

  1. This is very good postI get lot of help form this site for troubleshootings and error. This is another link where you can get solution for your problem.