{"id":459,"date":"2014-10-07T03:07:42","date_gmt":"2014-10-07T03:07:42","guid":{"rendered":"http:\/\/samwebman.wordpress.com\/?p=459"},"modified":"2014-10-07T03:07:42","modified_gmt":"2014-10-07T03:07:42","slug":"howto-create-sql-server-database-diagrams","status":"publish","type":"post","link":"https:\/\/www.intentrust.com\/?p=459","title":{"rendered":"HowTo Create SQL Server Database Diagrams"},"content":{"rendered":"<p>Reference from http:\/\/jochenj.wordpress.com\/2011\/03\/17\/howto-create-export-and-import-sql-server-2008-database-diagrams\/<\/p>\n<blockquote><p>Documentation and communication of custom database models and objects should be a task with high importance in every project and for every good database developer and administrator! Personally i advise one of the following approaches for generating MSSQL Database documentation:<\/p>\n<p><strong>1. Reengineer DB-Diagrams with Visio 2010<br \/>\n<\/strong><span style=\"font-size:xx-small;\">(Needs Visio 2010 Professional! <a href=\"http:\/\/office.microsoft.com\/en-us\/visio\/visio-edition-comparison-FX101838162.aspx\" target=\"_blank\" rel=\"noopener\">Only Professional Edition brings \u201cDB-reengineer\u201d feature!<\/a> Visio 2007 brings SQL2000\/2005 Support, and ONLY VISIO 2010 can read SQL2008 DBs. If you also think this is *** please vote at <\/span><a href=\"https:\/\/connect.microsoft.com\/SQLServer\/feedback\/details\/365757\/sql-server-2008-driver-for-visio-2007\" target=\"_blank\" rel=\"noopener\"><span style=\"font-size:xx-small;\">MS Connect<\/span><\/a><span style=\"font-size:xx-small;\"> for change)<\/span><\/p>\n<p><strong>OR\/AND<\/strong><\/p>\n<p><strong>2. Use SQL Server Management Studio (SSMS)\u00a0 ootb functionality &gt; Diagram Designer<\/strong><\/p>\n<p><strong>This post ist all about the second (Diagram Designer) approach:<\/strong><\/p>\n<p>With SSMS its easy to create DB-diagrams:<br \/>\n<a href=\"http:\/\/jochenj.files.wordpress.com\/2011\/03\/image.png\"><img loading=\"lazy\" title=\"image\" src=\"http:\/\/jochenj.files.wordpress.com\/2011\/03\/image_thumb.png?w=314&amp;h=124\" alt=\"image\" width=\"314\" height=\"124\" border=\"0\" \/><\/a><\/p>\n<p>With the integrated Diagram Designer you can produce multiple, nice looking diagrams, position tables and relationships as needed, create annotations\u2026<\/p>\n<p><a href=\"http:\/\/jochenj.files.wordpress.com\/2011\/03\/image1.png\"><img loading=\"lazy\" title=\"image\" src=\"http:\/\/jochenj.files.wordpress.com\/2011\/03\/image_thumb1.png?w=589&amp;h=414\" alt=\"image\" width=\"589\" height=\"414\" border=\"0\" \/><\/a><br \/>\n<em>Sample DB Diagram created with SSMS Diagram Designer<\/em><\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>Reference from http:\/\/jochenj.wordpress.com\/2011\/03\/17\/ &hellip; <\/p>\n<p class=\"link-more\"><a href=\"https:\/\/www.intentrust.com\/?p=459\" class=\"more-link\">\u95b1\u8b80\u5168\u6587<span class=\"screen-reader-text\">\u3008HowTo Create SQL Server Database Diagrams\u3009<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[53],"_links":{"self":[{"href":"https:\/\/www.intentrust.com\/index.php?rest_route=\/wp\/v2\/posts\/459"}],"collection":[{"href":"https:\/\/www.intentrust.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.intentrust.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.intentrust.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.intentrust.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=459"}],"version-history":[{"count":0,"href":"https:\/\/www.intentrust.com\/index.php?rest_route=\/wp\/v2\/posts\/459\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.intentrust.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=459"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.intentrust.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=459"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.intentrust.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=459"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}