Search code examples
sql-servermodelvisioenterprise-architect

SQL Server Extract Data Model

Is there a simple way of extracting the database model of existing DBs? I played around in the management studio and in Visio, even though I found very interesting features of data integration I failed to perform a simple export of the structure of the DB.

Could anyone pls give me a hint how to perform such an export, basically I only need the table and view names and their fields in a Visio or Enterprise Architect readable format.

thx in advance

K

Solution

  • First,

    thanks guys for the presented hints.

    I figured around and found that Visio 2k7 has a pretty easy to use DB reverse engineering functionallity which actually resolved my problem. It works with MS SQL and also with ODBC.

    To make it short: Visio ships with the needed functionallity, Enterprise Architect 7.1 has a quite similar functionallity which makes use of ODBC too.

    K