How to do with xml file -> schema file (fuction i .NET)

[Szaki]

I use a BulkLoad to import file.xml to my base MS Server 2000.
To import this xml file I need schema file. Mayby you know how to do this
file mechanicy f.g. mayby somebody have some script in .net who generate
this schema.
for any help Thanks

======== My xml file =============== =============== ===
<ROOT>
<Customers>
<CustomerId>555 5</CustomerId>
<CompanyName>Ja goda1</CompanyName>
<City>NY</City>
</Customers>
<Customers>
<CustomerId>020 0</CustomerId>
<CompanyName>To m Johnston</CompanyName>
<City>LA</City>
</Customers>
<Customers>
<CustomerId>199 </CustomerId>
<CompanyName>In stitute of Art</CompanyName>
</Customers>
</ROOT>
=============== =============== =============== ====

My schema . How to do this schema mechanicy? Becouse in this time I must do
this schema ofcourse writing.

=============== =============== MY Schema file ===============
<?xml version="1.0" ?>
<Schema xmlns="urn:sche mas-microsoft-com:xml-data"
xmlns:dt="urn:s chemas-microsoft-com:xml:datatyp es"
xmlns:sql="urn: schemas-microsoft-com:xml-sql" >

<ElementType name="CustomerI d" dt:type="int" />
<ElementType name="CompanyNa me" dt:type="string " />
<ElementType name="City" dt:type="string " />

<ElementType name="ROOT" sql:is-constant="1">
<element type="Customers " />
</ElementType>

<ElementType name="Customers " sql:relation="C ustomer">
<element type="CustomerI d" sql:field="Cust omerId" />
<element type="CompanyNa me" sql:field="Comp anyName" />
<element type="City" sql:field="City " />
</ElementType>

</Schema>

=============== =============== =============== ===========
Do you have any idea ???
Sorry for my english :)

--
Luk
lj**@wp.pl

[Christoph Schittko [MVP]]

Luk,

Take a look at the Schema Inference Tool on GotDotNet [0]. You can run
the tool there and download the code as well. It was developed by
members of the same team that is working on the System.Xml libraries in
the .NET framework.

HTH,
Christoph Schittko
MVP XML
http://weblogs.asp.net/cschittko

[0] http://apps.gotdotnet.com/xmltools/xsdinference/

-----Original Message-----
From: Szaki [mailto:lj**@gaz eta.pl]
Posted At: Friday, November 05, 2004 4:08 AM
Posted To: microsoft.publi c.dotnet.xml
Conversation: How to do with xml file -> schema file (fuction i .NET)
Subject: How to do with xml file -> schema file (fuction i .NET)

I use a BulkLoad to import file.xml to my base MS Server 2000.
To import this xml file I need schema file. Mayby you know how to do this file mechanicy f.g. mayby somebody have some script in .net who generate this schema.
for any help Thanks

======== My xml file =============== =============== ===
<ROOT>
<Customers>
<CustomerId>555 5</CustomerId>
<CompanyName>Ja goda1</CompanyName>
<City>NY</City>
</Customers>
<Customers>
<CustomerId>020 0</CustomerId>
<CompanyName>To m Johnston</CompanyName>
<City>LA</City>
</Customers>
<Customers>
<CustomerId>199 </CustomerId>
<CompanyName>In stitute of Art</CompanyName>
</Customers>
</ROOT>
=============== =============== =============== ====

My schema . How to do this schema mechanicy? Becouse in this time I must do
this schema ofcourse writing.

=============== =============== MY Schema file ===============
<?xml version="1.0" ?>
<Schema xmlns="urn:sche mas-microsoft-com:xml-data"
xmlns:dt="urn:s chemas-microsoft-com:xml:datatyp es"
xmlns:sql="urn: schemas-microsoft-com:xml-sql" >

<ElementType name="CustomerI d" dt:type="int" />
<ElementType name="CompanyNa me" dt:type="string " />
<ElementType name="City" dt:type="string " />

<ElementType name="ROOT" sql:is-constant="1">
<element type="Customers " />
</ElementType>

<ElementType name="Customers " sql:relation="C ustomer">
<element type="CustomerI d" sql:field="Cust omerId" />
<element type="CompanyNa me" sql:field="Comp anyName" />
<element type="City" sql:field="City " />
</ElementType>

</Schema>

=============== =============== =============== ===========
Do you have any idea ???
Sorry for my english :)

--
Luk
lj**@wp.pl