DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: XML to Database

  1. #1
    Join Date
    Jul 2007
    Posts
    4

    XML to Database

    I am now using SQLXML to load XML file into a SQLServer database.

    Here is how it works -

    XML(Data) + XSD(Schema) -->

    through MS SQLXML COM program (EXE) -->

    SQLServer2005

    ==================

    I though XML Schema is used for defining what kind of Element or
    attribute should appear in an XML document right?

    But from above example, XSD schema can also used to describe how XML
    document should be map to a Database table too???

    Then XSD can be think of a document that describe how One want to
    manipulate a specific XMLfile?

    So, XSD schema to be used to describe anything about data manipulate
    of an XML???

    Why not just use another XML to describe how to map data to database table??

    One can define a custom XML to describe on table mapping right??

    Why one need to study the XSD schema syntax (which is very complex) then use XSD to define the mapping to tables?

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,663
    Does this help?

Similar Threads

  1. Update database from XML file using DataSet
    By karthik in forum ASP.NET
    Replies: 0
    Last Post: 08-02-2003, 11:02 AM
  2. Replies: 0
    Last Post: 06-19-2003, 01:52 PM
  3. XML tutorials - fyi
    By Jeff Condon in forum XML
    Replies: 0
    Last Post: 05-29-2001, 02:25 PM
  4. XML Security
    By HSIN NING in forum XML
    Replies: 0
    Last Post: 08-21-2000, 12:17 AM
  5. Replies: 0
    Last Post: 08-14-2000, 07:22 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center