Jan
1
2014

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:

Link:
http://www.datanamic.com/dezign/

http://www.datanamic.com/dezign/mssqlserverindex.html

 

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,

http://www.codeproject.com/Articles/359080/Database-Diagrams-In-SQLServer

http://blogs.technet.com/b/damirb/archive/2005/12/10/415892.aspx

http://superuser.com/questions/578090/how-to-database-model-in-visio-2013

 

 

 

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 174 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

May 2019
M T W T F S S
« Nov    
 12345
6789101112
13141516171819
20212223242526
2728293031  

View Post by Categories

%d bloggers like this: