Post reply

database diagrams

  • July 30, 2009 at 12:47 pm

    #212758

    When i click on database diagrams after changing the dbo owner to sa, it creates a database diagram automatically but t doesnt work for all the databases.why so? please help?

    will the database diagram give the whole Entity relationship structure of the database?

    Thanks!!

  • July 30, 2009 at 1:21 pm

    #1032637

    It'll only work on defined foreign key constraints. Is it possible that the database(s) that won't render doesn't have those set up in it?

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • July 31, 2009 at 9:12 am

    #1033002

    so is there a way i can get the entity relationship diagram of a database?

  • July 31, 2009 at 9:34 am

    #1033025

    Describe what you see when you try to create a diagram for the databases it doesn't work. Do you get a message?

    Greg

  • July 31, 2009 at 10:38 am

    #1033064

    no i dont get any message.i am not trying to create for specific objects.

    what i really need is a entity relationship diagram of the database that gives a whole overview of the database objects & the entity relationship.

    if the database diagram can provide this, id like to know how it can be done..

    Thanks!!

  • July 31, 2009 at 11:10 am

    #1033081

    Does the database in question have foreign key constraints set up?

  • July 31, 2009 at 11:21 am

    #1033086

    Start by adding a table or group of tables to a new diagram. Select all tables and run "Add related tables". Repeat until no more tables are added. They will be all piled up together, so you can use automatic layout to spread them out. Then spend the rest of the afternoon rearranging the diagram.

    This will only pick up tables with defined foreign keys.

    If you have access to Visio, the "reverse engineer" function will pull in all table definitions.

  • July 31, 2009 at 11:36 am

    #1033095

    RedGate and ApexSQL also both sell software that's designed to help document SQL databases. I think you can get free trials from both. You might try those. Might be much better than a simple diagram.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 8 posts - 1 through 7 (of 7 total)

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