Generate Database diagram/ER diagram from SQL Azure database

• SQL!$@w$0ME

  SSChampion

  Points: 12349

  More actions

  June 30, 2016 at 9:01 pm

  #314790

  Hi Folks,

  How can I generate ER diagram from SQL Azure database. Is there a built-in functionality in SSMS 2016 or other free tools out there. Please share your thoughts.

  Many thanks!

• Grant Fritchey

  SSC Guru

  Points: 399047

  More actions

  July 1, 2016 at 4:48 am

  #1888042

  The best bet to do this would be to use one of the many mechanisms for getting the Azure SQL Database to a local server and creating a diagram there. I'm not aware of any free tool that does this. I'm also not sure if the pay tools support Azure.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning