I am unable to find the "Database Model" in Visio 2013 and upon linking an existing database to Visio, there is no option to Reverse Engineer. Where do I find this functionality?
Add a comment
|
2 Answers
Reverse Engineering in Visio 2013 has been removed, according to the Visio blog: https://www.microsoft.com/en-us/microsoft-365/blog/2012/10/17/uml-and-database-diagrams-in-the-new-visio/
Deprecations
The new software and database diagramming capabilities in Visio represent a departure from the capabilities of previous versions. We place a strong emphasis on diagramming and sharing instead of rigorous modeling. Specifically, there is no ability to generate a diagram from existing code or a database definition. Also - just like in recent releases - there is no ability to go from diagram to code or database. Existing UML and Database diagrams can be opened in the new Visio, but they are effectively frozen for editing since the previous feature set has been removed. The behavior of existing diagrams is equivalent to the experience you get today when opening them in Visio 2010 Standard.
There are alternatives:
- Use Visio 2010 instead. Note: If linking to SQL Server 2012, follow this suggestion.
- Visual Studio using the Entity Framework1: http://msdn.microsoft.com/en-us/data/jj206878
-
8You already know the answer, but I believe the VS Team took this functionality and put it into Entity Framework: msdn.microsoft.com/en-us/data/ee712907.aspx Apr 4, 2013 at 13:40
-
You might want to expand your answer by explaining what the user can do instead since this functionality has been removed. What are the remaining options, if any? Apr 4, 2013 at 19:40
-
14I don't see how EF is anywhere a replacement for the Visio functionality. In Visio you were presented with a way to make attractive versions of the diagram that could be used for printed materials/etc. EF pretty much does what the "Data Diagram" in SQL Server Management Studio does. Sep 12, 2013 at 17:10
-
not really, if you use database diagram in SMSS it doesn't automatically add relationships. May 5, 2017 at 0:56
A typical Microsoft move...take something that works, that the user community finds useful and remove it, in hopes of sticking it into another application to force that community to by another application for the one feature. It's cheaper to switch to a non MS application and avoid the hassle.
-
Welcome to Super User! Before answering an old question having an accepted answer (look for green ✓) ensure your answer adds something new or is otherwise helpful in relation to them. Here is a guide on How to Answer. There is also a site tour and a help center. Oct 6, 2022 at 17:13
-
This does not provide an answer to the question. Once you have sufficient reputation you will be able to comment on any post; instead, provide answers that don't require clarification from the asker. - From Review Oct 6, 2022 at 17:21