search

sridhar19091986 / wiresharkplugin

Automatically exported from code.google.com/p/wiresharkplugin
0 stars 0 forks source link

Export multiple tables to 1 XML file #12

Open GoogleCodeExporter opened 8 years ago

GoogleCodeExporter commented 8 years ago 
I have multiple tables which are linked to 1 main table.
E.g
Main - USERTABLE
Name
Age

COMPUTERTABLE
Speed
RAM

PRINTERTABLE
Model
Type

Note: A user can have multiple Computers/Printers/etc.

Is there a way in MSSQL2005 that extract this information to XML so it becomes
<USER>
<Name>Smith</Name>
<Computers>
<Computer>
<Speed>750</Speed>
<RAM>1Gig</RAM>
</Computer>
<Computer>
<Speed>2.4Gig</Speed>
<RAM>4Gig</RAM>
</Computer>
</Computers>
<Printers>
<Printer>
<Model>USB3460</Model>­
<Type>Flatbed</Type>
</Printer>
</Printers>
</USER>
<USER>
......
</USER>

Original issue reported on code.google.com by cn.wei.hp@gmail.com on 22 Dec 2010 at 12:38

GoogleCodeExporter commented 8 years ago 
Creating XML from Multiple tables

Original comment by cn.wei.hp@gmail.com on 22 Dec 2010 at 12:41

GoogleCodeExporter commented 8 years ago 
xsd.exe outer.xsd imported.xsd /classes /l:cs /n:MyNamespace

Original comment by cn.wei.hp@gmail.com on 22 Dec 2010 at 2:11