Tag Info

Hot answers tagged


The Generic OleDB Driver also works for reverse engineering a SQL Server 2012 database using Visio 2010.


I cannot test it from here, but I would try using the SQL 10 driver if you can. They usually have high level of compatibility across versions. Or else try using the Generic ODBC driver. That almost always works, though you don't always get as much with it.


The first, you should read the NORMALIZATION concepts (1NF,2NF,3NF,...) after that you can use them to verify your dependency diagram. So, I'm talking about some basic steps to help you convert ERD, which I often do: 1- Identify objects (objects are WHO, WHERE, WHAT, WHEN ), you imagine that they are exited and can be defined. 2- Identify natural keys of ...


I'd check out Embarcadero tools Try Data Architect.


You can't do that in Visio. However, you can reverse engineer a database using Visio. The answer to the question below should help you. How can I import the contents of an Oracle database into Visio to create an Entity Relationship Diagram?


You can use the "free" MySQL workbench if you are using MySQL https://www.mysql.com/products/workbench/ to reverse engineer the model from an SQL file then re-organize the model into multiple pages.

Only top voted, non community-wiki answers of a minimum length are eligible