How to create E-R diagrams for sql databases

SQLserver2005 how to automatically generate E-R diagram

With visio, reverse engineering is very simple, directly select the next step, start a new database – database model diagram, and then select the database – reverse engineering, select the ODBC, and then select the sql

server driver

, select your database, directly next step, it is very It’s very simple.

How to use visio will be SQLserver database, converted to E-R diagram

1, create a new visio2, select the drawing type for the software and database, and then select the database model diagram3, drag and drop the legend on the left side, basically with the entity and relationship can be completed.