Database Diagrams tool in SQLSERVER

  • Is there any Database Diagrams tool in SQLSERVER ?

    Hello :

    We are planning to design new Datawarehousing product. I am taking care of Database Design from start.

    I am looking for best database diagram tools - logical diagram component - BI

    Is there any seperate component/tool in sqlserver 2012 to achieve the process?

    Kindly help me on finding the best tools .

    Thanks in advance..!

    Regards,

    Pradeep

  • SQL has one built in, which you can get to by creating the database diagram in the database diagram under the database object in SSMS.

  • Is thier any other tools before creation of the tables logical diagram

  • Visio, Sybase Powerdesigner, sure if you do a search on Google (other search engines available) you will be able to find more.

  • I recommend Toad Data Modeler.

  • Just about any UML tool can help you create logical models.

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • I also use Toad Data Modeler. In addition, I don't know if newer versions of Visio support ERDs that well, if at all.

  • imani_technology (12/18/2012)


    I also use Toad Data Modeler. In addition, I don't know if newer versions of Visio support ERDs that well, if at all.

    Yes, they do, in the Premium Edition.

  • Good! Does that also apply to Visio 2010?

  • Yes, it does.

  • Wow, I wish I had known that earlier.

  • mpradeep23 (12/14/2012)


    Is thier any other tools before creation of the tables logical diagram

    Heh... cocktail napkins and beer coasters!

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • Jeff Moden (12/18/2012)


    mpradeep23 (12/14/2012)


    Is thier any other tools before creation of the tables logical diagram

    Heh... cocktail napkins and beer coasters!

    HAH!! Yep - that is about all I use for "logical" modeling too! 😎

    I have used Embarcadero's ERStudio for probably a dozen years now. Incredible capabilities, and if you purchase a SQL Server only license it is very reasonably priced for the functionality it brings to the table (pun intended). 😛

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • Be aware that the SQL Server database diagram is a live representation of the database. If you drop a table from the diagram it is dropped from the database, so use this tool with care. It can be safer to stick with the cocktail napkins and beer coasters, plus using a phone camera to capture significant versions.

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

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

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