generate an SQL Script as shown in the screenshot below. Once you have your ER diagram ready, you can generate an interactive HTML report, export the diagram to PDF or e.g. Use the display mode and/or line mode that best suits your needs. Step 5: Change the display mode and line mode You can add notes, images and other elements to the ER diagram. USE AdventureWorks GO / Object: StoredProcedure dbo. Now, Im using AdventureWorks 2012, because thats all I have. Rearrange items on the main diagram or on any sub-diagram. Here it is using a CTE, embedded in a procedure. Step 4: Change the layout and rearrange items To split the diagram, right click the diagram area and choose Add diagrams by Schemas. In Luna Modeler you can easily split the main diagram and automatically create a sub-diagram for each database schema. Step 3: Create sub-diagramsįor more convenient work with the ER diagram, it is a good idea to divide it into smaller parts. Go to the Connections page and click Connect and Load Existing Database Structure to reverse engineer the database and create the ER diagram. For example, the default location for a default instance of INCLUDE sssql19-md is:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |