synapsevampire
Programmer
I understand very little of using XML to create databases and seek your expertise.
I'm trying to learn how I might create the data structures as defined here in this XSD (or is it XML) file into a SQL Server 2000 database:
Are there tools that would read this and create the database, tables and other objects?
TIA,
-k
First part of the file:
.<!--
Salesforce.com Enterprise Web Services API Version 7.0
Generated on 2006-03-15 17:47:40 +0000.
Copyright 1999-2006 salesforce.com, inc.
All Rights Reserved
-->
.<definitions targetNamespace="urn:enterprise.soap.sforce.com">
.<types>
.<schema elementFormDefault="qualified" targetNamespace="urn:sobject.enterprise
<import namespace="urn:enterprise.soap.sforce.com"/>
<!-- Base sObject (abstract) -->
.<complexType name="sObject">
.<sequence>
<element name="fieldsToNull" type="xsd:string" nillable="true" minOccurs="
<element name="Id" type="tns:ID" nillable="true" minOccurs="0" maxOccurs="
</sequence>
</complexType>
.<complexType name="Account">
.<complexContent>
.<extension base="ens:sObject">
.<sequence>
<element name="Account_Short_Name__c" nillable="true" minOccurs="0" type
<element name="AnnualRevenue" nillable="true" minOccurs="0" type="xsd:do
I'm trying to learn how I might create the data structures as defined here in this XSD (or is it XML) file into a SQL Server 2000 database:
Are there tools that would read this and create the database, tables and other objects?
TIA,
-k
First part of the file:
.<!--
Salesforce.com Enterprise Web Services API Version 7.0
Generated on 2006-03-15 17:47:40 +0000.
Copyright 1999-2006 salesforce.com, inc.
All Rights Reserved
-->
.<definitions targetNamespace="urn:enterprise.soap.sforce.com">
.<types>
.<schema elementFormDefault="qualified" targetNamespace="urn:sobject.enterprise
<import namespace="urn:enterprise.soap.sforce.com"/>
<!-- Base sObject (abstract) -->
.<complexType name="sObject">
.<sequence>
<element name="fieldsToNull" type="xsd:string" nillable="true" minOccurs="
<element name="Id" type="tns:ID" nillable="true" minOccurs="0" maxOccurs="
</sequence>
</complexType>
.<complexType name="Account">
.<complexContent>
.<extension base="ens:sObject">
.<sequence>
<element name="Account_Short_Name__c" nillable="true" minOccurs="0" type
<element name="AnnualRevenue" nillable="true" minOccurs="0" type="xsd:do