Share via

Visio 2016 pro isn't allowing reverse engineer of database

Anonymous
2016-02-11T04:11:56+00:00

I just bought Visio Professional 2016 for the purposes of reverse engineering a database.

I have gone to File -> New -> Software -> Database Model Diagram and chose the crow's feet type.

There's no Database tab like older versions had, and the closest thing I found was under Data -> Custom Import and got menus to connect to my SQL Server, but it acts like it just wants to import data from a table, rather than an ERD.

What's the correct way to do this in 2016?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

29 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-02-11T14:40:13+00:00

    will that generate a Visio diagram?

    I can suck DBs into EF all day long.  I need an ERD as a visio diagram to hand to a client.

    If MS can't supply an obvious documentation generation problem, I'll get my money back on Visio.

    200+ people found this answer helpful.
    0 comments
  2. Anonymous
    2016-09-05T03:38:08+00:00

    I still keep a copy of VISIO 2010 installed just for MS SQL reverse engineering and EDR diagrams/documentation. What comes with Visual Studio is pathetic. But given nothing has happen in this area since 2010 I don't think Microsoft will start listening to their customers any time soon.

    10+ people found this answer helpful.
    0 comments
  3. Anonymous
    2016-02-11T13:43:27+00:00

    I'm very disappointed.  I research this product spoke to the chat support people who said yes the professional version does reverse engineering,  and was told it did and I purchased it yesterday and now I found out it doesn't.  I will be contacting them for a refund.

    8 people found this answer helpful.
    0 comments
  4. Anonymous
    2016-02-11T14:13:17+00:00

    reverse engineering with visio was dropped as a feature in v2013. Paul is correct in that the only tool that MS currently markets with that functionality is Visual Studio with Entity Framework.

    al

    7 people found this answer helpful.
    0 comments
  5. Scott Helmers 3,780 Reputation points MVP Volunteer Moderator
    2016-10-03T19:07:45+00:00

    I can provide good news -- at last week's Ignite conference in Atlanta, Microsoft announced that the database reverse engineering capability will be returning to Visio Pro for Office 365 by the end of the year.

    4 people found this answer helpful.
    0 comments