About this question
I have a database on SQL Azure and want to create a database diagram for that, but don't want to have to install SQL server and copy the database etc. Is there any way that I can do it that anyone knows of?
I have a database on SQL Azure and want to create a database diagram for that, but don't want to have to install SQL server and copy the database etc. Is there any way that I can do it that anyone knows of?
Log in to share your answer and help other learners.
Log in to answerBest Answer · By JanBask MS SQL Server Expert
Answered on Apr 16, 2021
SQL Azure databases do not support diagrams in the same way 'normal' on premise SQL Servers do, so you are looking at workarounds or third-party tools. For example, you could install SQL Server Data Tools (SSDT), pull your model down, deploy to a local 'normal' dev server, create the diagram there. This would not involve much data so would be lightweight. Alternately use Viso, Powerpoint, dbForge, Erwin, RedGate, Apex ... paper and pencil etc : ) A little additional research shows Red Gate have recently added more support for SQL Azure and have a free trial, and SQL Power Doc which looks useful and could plug into NodeXL for example. In summary, the tooling hasn't quite caught up but you have a few options.
Here Are The Steps To Create An Azure SQL Database
Free tutorials and interview questions from industry experts — learn the skill, then get ready to prove it.
Step-by-step SQL Server guides from industry experts
Common SQL Server interview questions, answered
Guides, tips and career advice on SQL Server from JanBask experts.
SQL Server Top 75 SSAS Interview Questions and Answers For Beginners & Experts
Prepare for your SSAS interview with our comprehensive guide featuring 75 top SQL Server Analysis Services interview questions…
SQL Server How to Become a SQL Database Administrator?
How to become a sql database administrator In 2025, discover what these professionals do, explore how much they earn and learn…
SQL Server OLAP vs OLTP: Key Differences, Architectures, Performance & Real-World Examples
Compare OLTP vs OLAP with clear definitions, architecture diagrams, real-world examples, and FAQs. Learn when to use each system…
SQL Server 70+ Most Asked SSIS Interview Questions for Freshers & Experienced
Prepare for your next SQL Server Integration Services (SSIS) interview with our top 70+ SSIS interview questions and answers.…