Missing Database Diagrams node for SQL Azure database in Microsoft SQL Server Management Studio SSMS 2012?

Question

When connecting to a windows azure SQL server database from SQL server management studio, the database diagrams node appears to be missing.

See attached image. I installed from 'en_sql_server_2012_enterprise_edition_x86_x64_dvd_813294' but can't find the option.

Maybe my DBA needs to enable diagramming? Per SQL Server Management Studio Display Database Diagrams (ER) Permissions

Answer 1

This appears to be SQL Azure and not SQL Server 2008 R2 (based on the presence of the Federations node in the supplied screenshot). Right now, your best bet to diagram the database is to create the database locally on SQL Server and generate the diagram from there. Hopefully the tooling catches up for SQL Azure soon!