If you have a comment on this topic, contact Aptify Documentation. If you want to return to the Aptify Community Site, please click here.

Creating an ERD Using SQL Server Management Studio

You can also create dynamic Entity Relationship Diagrams (ERDs) for Aptify entities using Microsoft SQL Server Management Studio.

Follow these steps:

  1. Launch SQL Server Management Studio and connect to the Aptify server as an administrative user.
  2. In the Object Explorer, expand the Databases folder to view a list of available databases.
  3. Expand the APTIFY database.
    • Right-click the Database Diagrams folder and select New Database Diagram.

       Create Database Diagram
  4. Select a table to add the diagram from the list provided. Click Add.

     Add Tables to Diagram
  5. Add additional tables as necessary. Click Close when finish.
    • The database diagram loads, displaying information about the table or tables you added.
       
  6. To add the tables related to a particular table in the diagram, right-click in a table's caption and select Add Related Tables from the pop-up menu.

    Adding Related Tables
    • SQL Server Management Studio adds the related tables to the diagram and displays the links between them. The figure below illustrates a sample diagram for the Committees entity and its related entities. 

       Sample Database Diagram
  7. Modify the diagram as necessary and save the results, if desired.

Copyright © 2014-2017 Aptify - Confidential and Proprietary