How do I make my ERDs more automatic?   

Hello all,

I am currently working on finding a way to automize VISIO. What I mean by 
this is that I want to find a way to create some sort of database that is 
connected to more than one Entity Relationship Diagram and, when I make a 
change on an object on the database, I want that change to be reflected in 
all ERDs that contain that particular object. These changes would be things 
such as font, color, relations to other objects, etc. 

Is there any way to do this? I only have basic computer skills so I need 
simple explanations.

Thank you

date: Tue, 17 Jun 2008 10:33:00 -0700   author:   Ivan Salas Ivan

RE: How do I make my ERDs more automatic?   

{\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fprq2\fcharset0 MS Sans Serif;}}
\viewkind4\uc1\pard\f0\fs26 The Visio ERD/Database Modeling solution doesn't have a public programming interface - it's not intended to be programmatically manipulated by developers.  Additionally, the shapes are connected to , and drawing/updated by the solution automatically, and most of the options in them are protected to prevent the kind of color/style changing you describe.  
\par 
\par This is an interesting idea - but there really isn't a way for you to circumvent the solution to accomplish it, unfortunately.  Each diagram maintains it's own connection to the database that it was created from - so you will need to open a diagram and trigger a Database Model Refresh to allow the drawing to get the latest updates from its connected database separately.
\par 
\par 
\par Barb Way
\par Product Support - Visio
\par Microsoft Corporation
\par [This posting is provided "As Is" with no warranties, and confers no rights.]
\par \pard\li720 --------------------
\par Thread-Topic: How do I make my ERDs more automatic?
\par 
\par 
\par Hello all,
\par 
\par I am currently working on finding a way to automize VISIO. What I mean by 
\par this is that I want to find a way to create some sort of database that is 
\par connected to more than one Entity Relationship Diagram and, when I make a 
\par change on an object on the database, I want that change to be reflected in 
\par all ERDs that contain that particular object. These changes would be things 
\par such as font, color, relations to other objects, etc. 
\par 
\par Is there any way to do this? I only have basic computer skills so I need 
\par simple explanations.
\par 
\par Thank you
\par \pard 
\par 
\par }

date: Mon, 30 Jun 2008 22:35:46 GMT   author:   (Barb Way)