Cannot export Visio 2007 ERD to SQL Server database

B

bbcrock

I reverse engineered our database in SQLServer Express 2005 to a Visio
2007 Pro Entity Relationship Diagram. I created new entities,
relationships and modified entities.

I distributed the ERD to different users who now need to forward
engineer this diagram to create new databases.

I have looked all over the application and cannot figure out how to:
1. Generate SQL DDL code from this ERD, which should be completely
standard functionality
2. Export the changes made in Visio to SQL Server which should also
be standard functionality

Every time I get into tools/Add-ins or the Database tab I get some
kind of situation where the shapes become records or something else
that is innapropriate. The shapes represent tables and columns and
need to be exported which is why we settled on this product.

What am I doing wrong?

thanks!
 
A

Al Edlund

you of course are aware that you have to use the visio version that comes
with visual studios enterprise architect edition to forward engineer a
database model.
al
 
B

bbcrock

you of course are aware that you have to use the visio version that comes
with visual studios enterprise architect edition to forward engineer a
database model.
al

<[email protected]> wrote in message
Click to expand...

I learned that later. Our reseller told us this functionality was
available when we purchased it, but it is not.
 
Top