Database ER Diagram Tool for SQL Server
dbForge Studio for SQL Server comes with an advanced ER diagram tool that allows creating Entity Relationship Diagrams and Relational Schemas quickly and easily.
dbForge Database Design Diagram tool functionality combines Database Diagram, Database Modeling, and Table Designer utilities to help you effectively perform various database tasks.
With our ERD diagram tool, you can:
Visualize database structure for further analysis
Use containers to cluster logically related objects
Inspect logical relations between tables
Print out large SQL database diagrams
Create and edit database objects right on a diagram
Reverse engineer database diagrams
Creating a Database Diagram
You can create a new SQL Server database diagram by simply dragging your database objects from Database Explorer to the diagram. Your new SQL database diagram will
reflect all the objects and existing connections simplifying further analysis.
Navigating the diagram is easy, just use the scrollbars, a mouse, or in-built navigation utilities. You can zoom in and out the diagram to simplify the navigating.
Database Diagram Visualization Tools
With dbForge Database Diagram Tool, you can customize diagram visualization to fit your needs.
Notations. You can choose between the two common data modeling notations:
- Information Engineering (IE)
- IDEF1 Extended (IDEF1X)
Relation comments. You can either enable or disable the rendering of foreign key names near the relation child ends.
Document outline window displays a logical structure of the currently opened SQL diagram. You can use it to navigate between tables and their relations on a database diagram.
Other visualization options. You can hide constraints, indexes, and triggers compartments, change its field detail level to display only column names, names with types, or names with full types.
Clustering logically related objects using containers
Containers. When you work with a large SQL database diagram, a container allows you to store logically related objects in one place. You can create a new container, put related tables inside, rename the container, and then collapse it.
Containers offer a logical packaging mechanism to clarify the structure of complex diagrams and are ideal for those working with large databases.
Tracking logical relations between tables
- Allow you to visualize logical relations between tables
- Do not exist physically and are only stored in the diagram
- Can be used to simplify the visual analysis of the data
- Can be materialized further into a physical relation
Virtual relation manager contains a list of the existing virtual relations and enables you to:
- Edit the existing virtual relations
- Generate a schema script taking into account selected virtual relations, edit the script, and execute it to update a database
- Convert a virtual relation into a foreign key
Printing a database diagram
Page options allow you to set the following page settings:
- Page orientation
- Paper size and source
- Printing margins and overlapping
- Header and footer text
Display print markup option displays the print markup grid. Gray stripes show the page overlapping, which can be adjusted.
Print options allow you to:
- Position printed image in the center
- Adjust diagram scale
- Set up printing of the page markup that helps to cut and glue together an SQL diagram that is printed on several sheets
Creating and editing database objects on a diagram
Creating and editing relations option can be accessed by right-clicking the line between two entities in the diagram area. The context menu of this option allows you to:
- Edit a foreign key using the foreign key editor
- Find a foreign key in database explorer
- Synchronize with document outline window
- Reroute a relation
- Show a relation comment
Creating and editing objects. You can create new database objects or edit the existing ones, right in the diagram area.
All the changes you have made to an object on a diagram are permanent and stored on a server.
The Note feature allows you to add comments to the diagram area while designing or analyzing a database structure. You can also add hyperlinks inside of your note to other resources. For instance, a hyperlink to wiki pages with database documentation.
Stamp displays the information about a database diagram and serves to identify a printed copy of the document.
Adding an arbitrary image to a diagram. This feature allows you to add additional visual information to the diagram area, such as a diagram sketch, or draft.
Searching text on the Database Diagram
dbForge Database Diagram Designer supports searching shapes by text. Database object shapes can be searched by their names and names of their elements (columns, constraints,
stored routine parameters, etc.). Search can also be performed in the stamp company name and project name fields, notes, relation comments, and container names.
Using additional diagram elements
Notes. Notes are yellow boxes with the text you can add to the diagram to explain some diagram parts. Notes can be moved, brought to front or sent to back, or resized like any other shapes on the diagram.
Hyperlinks. The note allows adding a hyperlink to a file if required.
Stamps. Diagram stamp enables you to specify the following information about the diagram: diagram author, company, version, copyrights, project name, date. You can add as many stamps to your diagram as you want.
Images. dbForge Studio allows adding images to your database relationship diagram. Images can be moved, brought to front, sent to back, or resized like any other shapes on the diagram. You can use the following image formats:
Reverse engineer to create a database model from an existing database
With the dbForge Database Diagram that displays the physical data model of an SQL Server database, reverse-engineering can be done quickly and effectively.
Reverse engineer the database diagram to:
- Create documentation on an application
- Provide developers with a better overall picture of the database schema
- Create a more comprehensive guideline when performing changes to the schema