Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I want to have a export from my database diagram to PDF or image types.How can I do this?
I worked with sql server 2008 R2.

share|improve this question
2  
An alternative solution - Microsoft Office Visio can reverse enginer a database (depending on the edition). –  Greenstone Walker Apr 4 '13 at 5:04
    
@GreenstoneWalker: thanks friend ;) –  Hamid Talebi Apr 4 '13 at 5:17

2 Answers 2

up vote 6 down vote accepted

There is no direct way to transform the standard SQL Server diagram to a PDF or an image file type. Actually there is no simple way to export the diagram from within the tool.

You can, however, save it externally and send it to someone by:

  • print to a file printer (an .xps file) which is formatted like a pdf and an XPS file viewer exists on any windows machine;
  • open the diagram and right click somewhere in the middle and you'll have there the option to "Copy diagram to clipboard". From here you paste to MSPaint or another image creator and save to wanted format;

Not very straightforward, but can do the job.

share|improve this answer
    
Thanks.Your answer help me.I want a document from my diagram in A4 or A3 paper. –  Hamid Talebi Feb 5 '13 at 10:48

SchemaCrawler is a free tool that can create database diagrams in PDF format, with help from GraphViz. You can search for tables that you want to include in your

Sualeh Fatehi, SchemaCrawler

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.