Use Visual Studio to create Database Diagrams.

By [)ia6l0 iii

Create Database diagrams with Visual Studio with easy steps.

Many of us use Microsoft Visio or the traditional SQL Server Management Studio to create Database diagrams. But off late due to the obvious cost-cutting measures in Enterprises, these licenses are not procured.

The good news is that you can use Visual Studio with the same set of features to create Database diagrams.

Here are the steps.
a) Open Visual Studio and open Server Explorer (CTRL + W + L is the Keyboard shortcut)
b) Open the SQL Server Data connection that you have added.
c) Right-click on Database Diagrams
d) and Choose "Add New Diagram" from the context menu
e) Add the Tables to the diagram.

You have the database diagram.

Use Visual Studio to create Database Diagrams.  (7551 Views)