Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

How to create a PDF database diagram in SQL Server?

Tags:

sql-server

pdf

er-diagrams

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
Sign in to Comment

Related questions

Disassembling Bit Flag Enumerations in SQL Server
Why won't this SQL CAST work? [closed]
Sql Server int vs nvarchar comparison on performance?
Update count column from data in another table
VS SQLCLR: Function X has unresolved reference to schema Y
Sql Server temporary table disappears
sql select min or max based on condition part 2
SQL Server Error 5120 - failed to attach .mdf file
How can I return a row if its ID is not found in another table?
SQL Server select results as string separated with ',' [duplicate]
SQL Server and Oracle, which one is better in terms of scalability? [closed]
java.sql.SQLException: I/O Error: SSO Failed: Native SSPI library
SQL/Query tools? [closed]
Twitter name length in DB
converting date from mm/dd/yyyy to dd/mm/yyyy in SSRS
Create synonym to all tables in a different database with a script
How to insert an auto_increment key into SQL Server table
SqlException: Login failed for user 'NT AUTHORITY\NETWORK SERVICE
How to determine whether the number is float or integer
How do I increase the timeout period for my stored procedure call (see error)?

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!