none
How to create ER diagram for large database RRS feed

  • Question

  • I have to create ER diagram for database with around 60 tables.

    Is there any easy way to do this? There is database diagram tool in SQL server but tables are too scattered away. It's difficult to arrange nicely and close to each other so at least it can fit A3 (somewhere around there)

    Thanks


    h2007

    Thursday, July 19, 2018 1:27 PM

All replies

  • Have you tried following the guide explaining use of database diagrams in this document?
    Work with Database Diagrams (Visual Database Tools)

    HTH,


    Phil Streiff, MCDBA, MCITP, MCSA

    Thursday, July 19, 2018 3:09 PM
  • I don't think 60 tables will fit in a A3 or similar size while being readable enough unless you only show them partially (e.g. only the table name and few columns). Manual rearrangement will be required in almost every tool.

    You can try using Excel (2016 or above) which provides data diagram view. In Excel go to Data tab->Click on From Other Sources->From SQL Server->Provide Connection Details->Click Next->Select DB Name->Check Enable selection of multiple tables checkbox->Select tables that you want to include in the diagram->Click Finish->Click OK on the Import Data dialogue box.

    Now click on the Manage Data Model button on the top ribbon on Data tab->Click Home->Click on Diagram View on the top ribbon. This will give you a diagrammatic view of the selected tables with all the columns and relationships. You can move around tables as per your printing requirements.


    HTH,
    Cheers!!
    Ashish
    Please mark it as Answered if it answered your question or mark it as Helpful if it helped you solve your problem.

    Thursday, July 19, 2018 3:32 PM
  • I have to create ER diagram for database with around 60 tables.

    Is there any easy way to do this? There is database diagram tool in SQL server but tables are too scattered away. It's difficult to arrange nicely and close to each other so at least it can fit A3 (somewhere around there)

    Thanks


    h2007

    Kind of a multiple step solution, but it might fit your needs.

    1. If you don't have Visual Studio, download the free Visual Studio 2017 Community Edition.

    2. Start a new project.  I would suggest Visual C# -> Console App (.NET Framework).

    3. On the Tools menu, select Extensions and Updates.

    4. On the Online tab, search for an install Entity Framework 6 Power Tools Community Edition.

    5.  If prompted exit Visual Studio and restart it.  Re-open your project.

    6. Right-click your project in Solution Explorer and click Manage Nuget Packages.

    7. Search for and install Entity Framework 6.

    8. Right-click your project in Solution Explorer, point to Add, and click New Item.

    10. On the Online tab, search for and install EntityFramework Reverse POCO Generator (by Simon Hughes).

    11.  Follow the instructions you'll see in after you add the item to your project.  It's very well documented.  Check out his website for more help if you so need.

    12.  When you click the Save button it will generate a .cs file underneath the file.  You can see it by clicking the little arrow to expand.

    13. Right-click that .cs file, point to Entity Framework, and click View Entity Data Model (Read-only).

    14. See if that fulfills your needs.  You will end up with something like this:

    Quite a few steps but it might give you the results you need if you don't want to do it in SSMS.

    Thursday, July 19, 2018 3:49 PM
  • is that extension available for visual studio community  v8.2 . Its not found when I search is it downloadable is there a direct link
    Friday, November 1, 2019 2:34 AM