Generate SQL Server Database Diagrams – tools tips

Came across a requirement where I need to generate database component chart and their relationships, though database diagram tool is available but it has some risks associated, hence just in order to generate component chart, third party tools are also available and can server purpose, below is just collection of such tools and related links for use of needy ones,



Using inbuilt Database Diagram Tool:

Just right Click on Database Diagrams and create new diagram >> Select the existing tables and if references are specified in the tables properly >> You will be able to see the complete diagram of selected tables. For further reference read below links,



Using DBVis (3rd Party):

All you have to do is to get the right JDBC – database driver for SQL Server, the tool shows tables and references orthogonal, hierarchical, in a circle, etc. just by pressing one single button.

Note: there is a pro version (not needed) and an open/free version should suffice the diagram generation

Link: http://www.minq.se/products/dbvis/


Using SQL Developer:

Link: http://sqldeveloper.solyp.com/


Using Snowflake Joins:

Link: http://snowflakejoins.com

For SQL statements try reverse snowflakes


Using DeZign for Databases:




Using Visual Studio:

Link: http://msdn.microsoft.com/en-us/library/ms171971.aspx

The Database Diagram Designer is a visual tool that allows you to design and visualize a database to which you are connected. When designing a database, you can use Database Diagram Designer to create, edit, or delete tables, columns, keys, indexes, relationships, and constraints. To visualize a database, you can create one or more diagrams illustrating some or all of the tables, columns, keys, and relationships in it.


Method to transfer Database Diagram from One SQL Server to another:

Link: http://jochenj.wordpress.com/2011/03/17/howto-create-export-and-import-sql-server-2008-database-diagrams/

Author explains a method to do the task using a stored procedure, code is provided in link above


Using DBSchema:

Link: http://www.dbschema.com/

It is paid software and free version has limitation of 12 tables, use if you need it on regular basis and can pay license fees.



Different data modeling tool analysis is provided at below link:

Link: http://www.databaseanswers.org/modelling_tools.htm

This covers good amount of tools available (including mentioned above) to serve the required purpose.



Some useful references,







Download PDF

About the Author: Nitin G

Indian born, trekker, biker, photographer, lover of monsoons. I've been working full time with SQL Server since year 2005 and blogs to post the content aquired during my research on new topics or fixing issues faced by me as a DBA while working in different kind of projects, hope some of my posts may helps others in SQLDBA community. Everything you read on my blog is my own personal opinion and any code is provided "AS-IS" with no warranties!

Leave a comment

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 263 other subscribers

Translate this blog!



December 2020
« Nov    

View Post by Categories

%d bloggers like this: