Create Table DML from raw Visio XML for database model diagram


J

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.
 
Ad

Advertisements

B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top