How to create a database diagram for SQL Azure without having to install SQL Server?
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?
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
- Sign Up for Azure. ...
- Visit the Microsoft Azure Portal. ...
- Select SQL Database from the Left Menu.
- In SQL Databases screen, click Create SQL Databases or Add Button.
- Complete the Form. ...
- The new database will show up in the main screen once Azure has completed provisioning it.