Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Er Diagram

Answered Er Diagram

  • Monday, February 25, 2013 7:06 PM
     
     
    Sign In to Vote
    0

    Hi 

    i have one script, which i am using to load multiple destination table from my staging area 

    now i want to create ER Diagram based on that script, is there any easy way to create Diagram using just that script, or any tool which make life easier..

    thanks  

     

All Replies

  • Tuesday, February 26, 2013 12:39 PM
     
     Answered
    Sign In to Vote
    0

    Execute scripts in SQL Server, and create DB diagrams using Database Diagram feature. Use this link for more information.

    Regards,

    Phani Note: Please vote/mark the post as answered if it answers your question/helps to solve your problem.

     
  • Wednesday, February 27, 2013 8:12 PM
     
     Answered
    Sign In to Vote
    0

    One caution to use SQL Server's Database Diagram feature is that any change you make in the diagram, then you save the diagram, it updates the database structure.

    We use Visio to create Database diagrams, then craete tables after diagram is approved.

    There is a CodePlex project to generate scripts from Visio, but I have not used it.

    Thomas

    TheSmilingDBA Thomas LeBlanc MCITP 2008 DBA