dbForge Studio for SQL Server
All-in-One SQL Server GUI Tool
A powerful integrated development environment for SQL Server development, management, administration, data analysis, and reporting
You can create a new SQL Server database diagram simply dragging your database objects from Database Explorer to the diagram. Your new SQL database diagram will reflect all objects and existing connections simplifying further analysis.
Notations. You can choose the syntax between two common data modelling notations:
Relation comments. You can either enable or disable the rendering of foreign key names near the relation child ends.
Document outline window shows a logical structure of the currently opened SQL diagram. You can use it to navigate between tables and their connections on a database diagram.
Diagram overview window allows you to get a better overview of large diagrams. Using this window you can:
Skin type. There are three predefined skins:
Other visualization options. You may hide constraints, indexes, and triggers compartments, change its field detail level to display only column names, names with types, or names with full types.
Virtual relation manager contains a list of existing virtual relations, and allows you to:
Page options allows you to set such page settings as:
Display print markup option shows you the print markup grid. Gray stripes of the grid show the page overlapping, which is adjustable.
Print options allow you to:
Creating and editing relations that is displayed as a line between two entities in the diagram area. The context menu of this line allows you to:
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.
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 a database documentation.
Stamp displays the information about a database diagram, and serves to identify a printed copy of the document.
Adding of 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.