Creating a Database ER diagram with inputs from XML file

[Vasanth Kr. Mannam]

Hi All,

I have a equirement of creating a database ER diagram with the information
present in the XML file. For My database the scripts are in XML file and i
want to use this xml file in visio to create ER Diagram. IS this possible
through VISIo. Can anyone provide me idea of how to implement this.

Thanks in Advance,
- - Vasanth Kr.

 

[Chang Oh]

Visio does not support the XML data source unless you have an ODBC driver or
OLE DB driver that can read from the XML file.

Chang Oh
Visual Studio Team System

 

[Vasanth Kr. Mannam]

Hi Chang,

I have both of these installed on my machine. But how can I makeVisio to
read XML.

Here are the full details of my requirements.
I have one XML file with the definitions of tables to be created for my
project. I wanna write XSLT over this XML to convert it into the form
required for VISIO.

How can I user XML file with VISIO and what are the different XML formats
required for VISIO.

How can I read the table information from XML file and convert it into a ER
Diagram of VISIO.

Do you suggest me any other ways to to implement this.

Thanks & Regards,
- - Vasanth

 

[Vasanth Kr. Mannam]

Hi Chang,

I have both of these installed on my machine. But how can I makeVisio to
read XML.

Here are the full details of my requirements.
I have one XML file with the definitions of tables to be created for my
project. I wanna write XSLT over this XML to convert it into the form
required for VISIO.

How can I user XML file with VISIO and what are the different XML formats
required for VISIO.

How can I read the table information from XML file and convert it into a ER
Diagram of VISIO.

Do you suggest me any other ways to to implement this.

Thanks & Regards,
- - Vasanth

 

[Vasanth Kr. Mannam]

Hi Chang,

I have both of these installed on my machine. But how can I makeVisio to
read XML.

Here are the full details of my requirements.
I have one XML file with the definitions of tables to be created for my
project. I wanna write XSLT over this XML to convert it into the form
required for VISIO.

How can I user XML file with VISIO and what are the different XML formats
required for VISIO.

How can I read the table information from XML file and convert it into a ER
Diagram of VISIO.

Do you suggest me any other ways to to implement this.

Thanks & Regards,
- - Vasanth

 

[Al Edlund]

For Visio consider the office product defintion download.

http://www.microsoft.com/downloads/...52-3547-420a-a412-00a2662442d9&DisplayLang=en

For heavy xml use I've been impressed with the Altova product (xmlspy 2005).

Al

 

[Chang Oh]

You will need an OLE DB Provider or ODBC driver that can work against the
XML file such that it acts like it is connecting to a database. I am not
sure if such drivers exist in the market place, but I do know of someone who
was building his own OLE DB Provider for his own XML document.

Chang