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!
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!