Creazione tabelle da file xsd

Matteo Migliore

2004-04-01 18:24:30 UTC

Ciao.

E' possibile.

Ci sono vari metodi:
-1) caricare lo schema tramite il metodo ReadXmlSchema dell'oggetto DataSet
di ADO.NET (Framework)
- 2) utilizzare Access (l'ho provato solo con il 2003), menù File - Carica
dati esterni - Importa, selezioni l'XSD infine importi la tabella appena
creata in SQL Server tramite l'utility d'importazione di Enterprise Manager

Teo.

Post by Claudio Maccari
Ciao a tutto il NG
Vorrei chiedervi se e possibile creare delle tabelle partendo da uno
file xsd ( vedi esempio qui di seguito)
Grazie
Claudio
<?xml version="1.0" ?>
<xs:schema id="LimitiZonali"
targetNamespace="http://tempuri.org/test.xsd"
xmlns:mstns="http://tempuri.org/test.xsd"
xmlns="http://tempuri.org/test.xsd"
xmlns:xs="http://www.w3.org/2001/XMLSchema"
xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"
attributeFormDefault="qualified" elementFormDefault="qualified">
<xs:element name="LimitiZonali" msdata:IsDataSet="true"
msdata:Locale="it-IT" msdata:EnforceConstraints="False">
<xs:complexType>
<xs:choice maxOccurs="unbounded">
<xs:element name="LimiteZonale">
<xs:complexType>
<xs:sequence>
<xs:element name="DA" type="xs:string" minOccurs="0" />
<xs:element name="A" type="xs:string" minOccurs="0" />
<xs:element name="Ora1" type="xs:string" minOccurs="0" />
<xs:element name="Coefficiente_Ora1" type="xs:string"
minOccurs="0" />
<xs:element name="Ora2" type="xs:string" minOccurs="0" />
<xs:element name="Coefficiente_Ora2" type="xs:string"
minOccurs="0" />
<xs:element name="Ora3" type="xs:string" minOccurs="0" />
<xs:element name="Coefficiente_Ora3" type="xs:string"
minOccurs="0" />
<xs:element name="Ora4" type="xs:string" minOccurs="0" />
<xs:element name="Coefficiente_Ora4" type="xs:string"
minOccurs="0" />
<xs:element name="Ora5" type="xs:string" minOccurs="0" />
<xs:element name="Coefficiente_Ora5" type="xs:string"
minOccurs="0" />
<xs:element name="Ora6" type="xs:string" minOccurs="0" />
<xs:element name="Coefficiente_Ora6" type="xs:string"
minOccurs="0" />
<xs:element name="Ora7" type="xs:string" minOccurs="0" />
<xs:element name="Coefficiente_Ora7" type="xs:string"
minOccurs="0" />
<xs:element name="Ora8" type="xs:string" minOccurs="0" />
<xs:element name="Coefficiente_Ora8" type="xs:string"
minOccurs="0" />
<xs:element name="Ora9" type="xs:string" minOccurs="0" />
<xs:element name="Coefficiente_Ora9" type="xs:string"
minOccurs="0" />
<xs:element name="Ora10" type="xs:string" minOccurs="0" />
<xs:element name="Coefficiente_Ora10" type="xs:string"
minOccurs="0" />
<xs:element name="Ora11" type="xs:string" minOccurs="0" />
<xs:element name="Coefficiente_Ora11" type="xs:string"
minOccurs="0" />
<xs:element name="Ora12" type="xs:string" minOccurs="0" />
<xs:element name="Coefficiente_Ora12" type="xs:string"
minOccurs="0" />
<xs:element name="Ora13" type="xs:string" minOccurs="0" />
<xs:element name="Coefficiente_Ora13" type="xs:string"
minOccurs="0" />
<xs:element name="Ora14" type="xs:string" minOccurs="0" />
<xs:element name="Coefficiente_Ora14" type="xs:string"
minOccurs="0" />
<xs:element name="Ora15" type="xs:string" minOccurs="0" />
<xs:element name="Coefficiente_Ora15" type="xs:string"
minOccurs="0" />
<xs:element name="Ora16" type="xs:string" minOccurs="0" />
<xs:element name="Coefficiente_Ora16" type="xs:string"
minOccurs="0" />
<xs:element name="Ora17" type="xs:string" minOccurs="0" />
<xs:element name="Coefficiente_Ora17" type="xs:string"
minOccurs="0" />
<xs:element name="Ora18" type="xs:string" minOccurs="0" />
<xs:element name="Coefficiente_Ora18" type="xs:string"
minOccurs="0" />
<xs:element name="Ora19" type="xs:string" minOccurs="0" />
<xs:element name="Coefficiente_Ora19" type="xs:string"
minOccurs="0" />
<xs:element name="Ora20" type="xs:string" minOccurs="0" />
<xs:element name="Coefficiente_Ora20" type="xs:string"
minOccurs="0" />
<xs:element name="Ora21" type="xs:string" minOccurs="0" />
<xs:element name="Coefficiente_Ora21" type="xs:string"
minOccurs="0" />
<xs:element name="Ora22" type="xs:string" minOccurs="0" />
<xs:element name="Coefficiente_Ora22" type="xs:string"
minOccurs="0" />
<xs:element name="Ora23" type="xs:string" minOccurs="0" />
<xs:element name="Coefficiente_Ora23" type="xs:string"
minOccurs="0" />
<xs:element name="Ora24" type="xs:string" minOccurs="0" />
<xs:element name="Coefficiente_Ora24" type="xs:string"
minOccurs="0" />
</xs:sequence>
</xs:complexType>
</xs:element>
</xs:choice>
</xs:complexType>
</xs:element>
</xs:schema>