Using Database entries to dynamically create a visio diagram

sql database diagram visio flowchart
Kolten picture Kolten · Oct 3, 2008 · Viewed 8.3k times · Source

Is this possible?

We have a Configuration Management Database that stores information such as our servers, what datacentre they're stored in, applications that reside on them, as well as interfaces that send data from one application to another.

We would like to use Visio to connect to our SQL 2005 database, and automatically generate a flow diagram that details these dependancies and relationships.

So again - is this possible? If so, does anyone know of some documentation that details how to do this?

Answer

Vijesh VP picture Vijesh VP · Oct 3, 2008

Is this what you are looking out for?

Related questions

Azure data studio schema diagram?

I just recently downloaded Azure Data Studio with SQL Server Express since I'm using Linux . Is there an entity-relationship diagramming feature, kind of how SQL Server Management Studio has a database diagram feature? I want to visually see the relationships …

Read More
Insert into ... values ( SELECT ... FROM ... )

I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL engine of the day (…

Read More
What is the difference between "INNER JOIN" and "OUTER JOIN"?

Also how do LEFT JOIN, RIGHT JOIN and FULL JOIN fit in?

Read More