Problems with XSD schema mapping to SQL Server schema 
Author Message
 Problems with XSD schema mapping to SQL Server schema

Define "problems mapping", there are several things that I've run into so
far that would fit that description.

Jay McVinney
The ASP FAQ is maintained at http://www.***.com/


Quote:
> I have a complex type called 'products' which has various products with
> relate to an exhibit which I'm having problems mapping. I've attached a
> diagram with my table structure.

> I have a table containing lots of different products. The
> 'ems_exhibit_products' is used to create a relationship between the
> 'ems_exhibit' and the 'ems_product' table so I can specify more than one
> product for each exhibit entry and reduce data replication. Now, the
problem
> I'm having is structuring the output correctly. I want my 'products'
element
> to be structed like the following:

> <products>
>   <product product_id="1">
>     <name>product 1</name>
>    <description>This is product 1</description>
>   </product>
>   <product product_id="2">
>     <name>product 2</name>
>    <description>This is product 2</description>
>   </product>
>   .......
> </products>

> I've already defined these elements in my XSD if u care to take a look :)
> but haven't mapped them yet.

> Any ideas on this ?

> Cheers,
> Jon



Fri, 11 Mar 2005 08:08:08 GMT
 Problems with XSD schema mapping to SQL Server schema

Well the problem I'm having is mapping the database schema to xml schema
without having to redesign my database structure.

I accomplished the required result using CREATE VIEW, but I was wondering if
anyone had any other/better ideas?.

Cheers.


Quote:
> Define "problems mapping", there are several things that I've run into so
> far that would fit that description.

> Jay McVinney
> The ASP FAQ is maintained at http://www.aspfaq.com



> > I have a complex type called 'products' which has various products with
> > relate to an exhibit which I'm having problems mapping. I've attached a
> > diagram with my table structure.

> > I have a table containing lots of different products. The
> > 'ems_exhibit_products' is used to create a relationship between the
> > 'ems_exhibit' and the 'ems_product' table so I can specify more than one
> > product for each exhibit entry and reduce data replication. Now, the
> problem
> > I'm having is structuring the output correctly. I want my 'products'
> element
> > to be structed like the following:

> > <products>
> >   <product product_id="1">
> >     <name>product 1</name>
> >    <description>This is product 1</description>
> >   </product>
> >   <product product_id="2">
> >     <name>product 2</name>
> >    <description>This is product 2</description>
> >   </product>
> >   .......
> > </products>

> > I've already defined these elements in my XSD if u care to take a look
:)
> > but haven't mapped them yet.

> > Any ideas on this ?

> > Cheers,
> > Jon



Fri, 11 Mar 2005 16:52:20 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Problems using XSD mapping schema to return XML from SQL 2000

2. retrieve XML data from SQL server by using XSD mapping schema

3. retrieve XML data from SQL server by using XSD mapping schema

4. problem using XSD mapping schema

5. Using sql:is-constant and XSD Schema Mapping

6. Mapping a XSD to a SQL schema

7. using XSD as mapping schema

8. HELP: POST updategram to virtual root using mapping schema xsd

9. XSD mapping schema or XML EXPLICIT?

10. XSD-Mapping-schema with XML-Bulk load

11. xs:choice and mapping in XSD schema

12. XSD Mapping Schema for templates...


 
Powered by phpBB® Forum Software