How to reverse-engineer DB schema from SQL Server

[jaybright]

Hi There,

Is there anyway to reverse-engineer graphical DB schema from MS SQL Server 2008 using EA? I'm using EA 7.5, which was released in 2009, but if necessary, I can upgrade to 9.x.

Thanks,

Jay

[qwerty]

No idea what you mean by "graphical" but you can build a class structure by importing a DB schema from MS SQL Server. No need to upgrade.

q.

[jaybright]

Thanks. It's pretty close to what I needed. Is it possible to build a data modeling diagram, which has tables, PK, FK, UK, their relationships, etc, by importing a DB schema from MS SQL Server?

[hd]

Yes. The import takes care of the graphics. Just import into a class diagram.

http://www.sparxsystems.com/enterprise_architect_user_guide/9.2/database_engineering/importdatabaseschemafromod.html

[jaybright]

I tried the link, and it worked. Thanks a lot.