Reverse Engineer Database - Update Tables

Posted on 2012-09-10
Last Modified: 2012-09-11
I have a SQL Server database that I reverse engineered into a Visio ERD. After spending quite some time working with the layout of the 50+ tables I'd selected, I realized I missed one table. Without pulling in ALL of the tables again, in which case I'd have to redo the layout, is there some way to go back and pull in just one table, along with the related primary and foreign keys? The alternative is to try to manually just draw the table.

I am using Visio Professional 2012 with SQL Server 2008 R2.
Question by:dbbishop
    LVL 76

    Expert Comment

    You can try importing again and limit to the one table you missed.
    Have not tried it myself so can say that it works.
    LVL 51

    Accepted Solution

    Yep, can use the reverse engineer tool again and select just the one table you want to add...

    See :  for verification of the above.

    Also a tutorial showing table selection :

    While the above is not Visio 2012 I am told it still works pretty much the same way for selecting tables.

    Bit curious though... you must have selected individual objects before, or, the table has been added since (and you did a select all). So, the process is pretty much what you did before.

    Just to be safe though... Create a new diagram, use the Reverse Engineer tool, select a few tables and modify a bit in Visio, then repeat adding in a couple of other tables.
    LVL 15

    Author Closing Comment

    I had to manually add the FK relationships, even though I selected FK checkbox, but that worked. Thks.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Suggested Solutions

    The ability to add structure to Visio diagrams using containers, lists and callouts is one of my favorite features in Visio 2010. In this article we’ll examine containers. We’ll explore lists (…
    Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now