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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top