SQL Database Schema

  • Juanita

    SSCertifiable

    Points: 5300

    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

  • Jeremy-475548

    Hall of Fame

    Points: 3035

    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?

  • Juanita

    SSCertifiable

    Points: 5300

    Yes, I saw that but can you print that?

  • Jeremy-475548

    Hall of Fame

    Points: 3035

    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.

  • Juanita

    SSCertifiable

    Points: 5300

    Thank you sooo much !!! Perfect !!

  • Jeremy-475548

    Hall of Fame

    Points: 3035

    Your welcome

  • Juanita

    SSCertifiable

    Points: 5300

    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

  • Jeremy-475548

    Hall of Fame

    Points: 3035

    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.

  • Juanita

    SSCertifiable

    Points: 5300

    Jeremy,

    Thanks so much. Great ideas. I'll give them a try.

    I really appreciate all your help !!

    Juanita

  • Cory E.

    SSCertifiable

    Points: 7076

    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

  • Jeremy-475548

    Hall of Fame

    Points: 3035

    Not sure if this applies to a 2000 database though...

  • Cory E.

    SSCertifiable

    Points: 7076

    Jeremy (2/15/2008)


    Not sure if this applies to a 2000 database though...

    Good call - I missed that it was 2000 - sorry!

    -- Cory

  • Juanita

    SSCertifiable

    Points: 5300

    HI..yes, we are running sql 2000 standard edition.

    Juanita

Viewing 13 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply