How to create a PDF database diagram in SQL Server?

sql-server pdf er-diagrams
l15a picture l15a · Jun 14, 2012 · Viewed 41.1k times · Source

I have a relatively small database that I would like to generate a diagram for and then create a pdf of that diagram. I have the diagram created in SQL Server (all tables would fit on one page of a pdf document) but cannot figure out how to export it to a document. Is this possible? The only option I've found is to copy it to the clipboard and then paste it into a Word Document but the quality isn't very good.

Answer

Shahidul Islam Molla picture Shahidul Islam Molla · May 5, 2017

Using SQL Server Management Studio 2014:

  1. Right click diagram area
  2. On the menu bar select "Database Diagram" >> "Copy diagram to Clipboard"
  3. Open MS Word and paste it

Related questions

Converting from base64 string to varbinary(max) in SQL Server

I have PDF documents stored in my table as binary, the column that stores the bytes for the PDFs is type varbinary(max). I want to update one record with an updated document in SQL Studio, the way I am …

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More
How do I perform an IF...THEN in an SQL SELECT?

How do I perform an IF...THEN in an SQL SELECT statement? For example: SELECT IF(Obsolete = 'N' OR InStock = 'Y' ? 1 : 0) AS Saleable, * FROM Product

Read More