Create Table DML from raw Visio XML for database model diagram

[jamesrees]

Hi,

I'm trying to create table DML from the raw XML .vdx file created by visio
for a database model diagram template.
I can easily find the table & column names in the XML but can't find the
column type or size (datetime, bigint, varchar(255), etc).
I know SQL can be generated & this could be used - but I want to bypass this
and go straight from the raw XML to the format I want.
Anyone know where the data I need is stored in the XML?

Thanks.
James.

 

[Barb Way]

The Model information is embedded in the objects and the model itself, not
in shape properties. There is no documentation for the file structure
which allows you to decode that information.

If you need to extract information from a database model diagram, you would
need to use the Visio for Enterprise Architects and either Generate the
DDL, or Export to the ERWin ERX file type.

Barb Way
Product Support - Visio
Microsoft Corporation
[This posting is provided "As Is" with no warranties, and confers no
rights.]
--------------------

Hi,

I'm trying to create table DML from the raw XML .vdx file created by visio
for a database model diagram template.
I can easily find the table & column names in the XML but can't find the
column type or size (datetime, bigint, varchar(255), etc).
I know SQL can be generated & this could be used - but I want to bypass
this
and go straight from the raw XML to the format I want.
Anyone know where the data I need is stored in the XML?

Thanks.
James.