Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to create a PDF database diagram in SQL Server?

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.

like image 289
l15a Avatar asked Jun 14 '12 15:06

l15a


People also ask

How do I create a SQL database diagram?

To create a new database diagramIn Object Explorer, right-click the Database Diagrams folder or any diagram in that folder. Choose New Database Diagram on the shortcut menu. The Add Table dialog box appears. Select the required tables in the Tables list and click Add.

How do I export a SQL Server Database Diagram?

Export SQL relationship diagram To export a diagram to an image, follow these steps: Right-click the diagram and select Export to Image from the shortcut menu. Specify the target file name and image format. Click the Save button.

Can We Save PDF in SQL Server database?

Using file table, any documents or PDF or for that matter any file can be stored in the SQL Server.


2 Answers

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
like image 168
Shahidul Islam Molla Avatar answered Nov 02 '22 10:11

Shahidul Islam Molla


To display your diagram in PDF format, follow the below steps:

  • Click anywhere in the diagram area
  • Right click -> Copy to clipboard
  • Paste it in paint window
  • Save it as a png image
  • Open browser and search for png to pdf converter online tool
  • Convert it to pdf
like image 23
user2090846 Avatar answered Nov 02 '22 10:11

user2090846