February 15, 2008 at 9:30 am
HI,
Our CIO has asked for me to provide a schema for one of my sql 2000 databases. Is there a tool in enterprise manager that can do this? The database has about 80 tables in it.
Thanks so much,
Juanita
February 15, 2008 at 9:40 am
underneath your database, you should have a "diagram" thingy. You can select all tables, and it will make a nice picture for you. Is this what you're after?
February 15, 2008 at 9:42 am
Yes, I saw that but can you print that?
February 15, 2008 at 9:49 am
Sure.
First right click on the white empty space, and choose Show Page Breaks. This tells you the page layout.
In the toolbar up above, click on the magnifying glass and choose 50% or so, which will make it easier to see more and rearrange your tables onto a few pages.
If you have alot of tables, consider going to Right Click |Page Setup, and change the scaling of the graphics to 50 or 75% or so, and that will allow you to fit more tables on one page.
There is a print button on the toolbar, and under the right click menu.
Hope this helps.
February 15, 2008 at 11:18 am
Thank you sooo much !!! Perfect !!
February 15, 2008 at 11:26 am
Your welcome
February 15, 2008 at 1:44 pm
Well this works perfectly .. it does exactly what I want but now the question is, how can I email this diagram to the cio? So I guess the real question is, can you save the diagram to somekind of word document to where a typical pc user can view it without having to have special software installed on their pc.
Thanks so much !!
Juanita
February 15, 2008 at 1:54 pm
When you press the print icon, and the dialog box appears asking you where you want to print to, check to see if you have something called the "Microsoft Office Document Image Writer". You may have to do some finagling from there to get it in the format you want like save it to .tif format.
The other option is to just take some screenshots (your print screen button) paste it into Paint, and take what you want, paste it into Word, and then email it.
I'm sure there's gotta be less painful methods, but I've used both methods in the past to email schema diagrams around.
February 15, 2008 at 1:56 pm
Jeremy,
Thanks so much. Great ideas. I'll give them a try.
I really appreciate all your help !!
Juanita
February 15, 2008 at 1:58 pm
a quick google search resulted in this site (http://blogs.technet.com/damirb/archive/2005/12/10/415892.aspx[\url]) saying:
Exporting Database Diagrams from SQL Server Management Studio
A question that arose at one of the stops on the SQL Server 2005 Launch Tour was How do I export database diagrams I create in SQL Server Management Studio to another application? The answer to this question depends on what you want to do with the diagram after you export it.
If you want to be able to change it and then re-import it back into SQL Server Managament Studio, there is no easy way to do so. For this functionality you are better off using Microsoft Office Visio 2003 to create the diagrams and maintain them in that environment.
If you need to export the database diagram for inclusion into a document or in some way preserve the current image of the database, you can copy the diagram to the clipboard by selecting Copy Diagram to Clipboard from the Database Diagrams menu option. Once the diagram is copied to the clipboard you can paste it into any application that supports images such as Microsoft Office Word, PowerPoint and others.
-- Cory
February 15, 2008 at 2:00 pm
Not sure if this applies to a 2000 database though...
February 15, 2008 at 2:05 pm
Jeremy (2/15/2008)
Not sure if this applies to a 2000 database though...
Good call - I missed that it was 2000 - sorry!
-- Cory
February 15, 2008 at 2:08 pm
HI..yes, we are running sql 2000 standard edition.
Juanita
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply