xml to SQL -- dotnet xml

bubb
9/3/2003 5:53:44 AM

Hey we have a project in which a company produces a XML page in reply to
actions on it's site.
I see that SQL 2000 works well with XML so Can someone point me in the right
direction,
I would like to take the XML from thier SQL and have it "post" to own sql
server (add,create, data, modifity and delete data on the fly).
I was looking at doing XML to HTML and then passing to some a ASP but if we
can grab from the responsetext then we could save time and headaches.
Now I really know next to nothing about XML but I am reading all the
newsgroups and pulled now TONS of xml / sql stuff to play with.

So should I be looking at openxml or what

Background info..
we run server 2000 / SQL 2000 and have good ASP / SQL programmers on staff
(not me)

Below is the data which comes back from our "POST" to their server.
Our customer go to "our" website they fill in forms the forms are posted to
our server
and to a second compaines server which then response to the post with the
the xml data which we are at this time using MANY work arounds to get the
data into our database.

We have all the client data in our sever we just need to "post" the currenty
status code to the customer records.

------------------>
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE CDR SYSTEM "http://theotherdomain.com/xml/push/cdr.dtd">
<CDR>
<ClientID>RETURN_id_1</ClientID>
<DID>Deliv_Id_1</DID>
<Status="100" Description="Successful"/>
<Product>
<ClientTID>RETURN_id_2_1</ClientTID>
<DID>-1</DID>
<Status="101" Description="Service not needed at this time"/>
</Product>
</CDR>

Thanks for any and all help.

Bubba
<---------------------------------------------------------------------

SQL Server Development Team [MSFT]
9/3/2003 11:55:42 AM

Start with http://www.microsoft.com/sql/techinfo/xml/default.asp this link
and download SQLXML (SQL2000 WS toolkit)

The approach is to use the SQLXML Template functionality with UpdateGrams.
This allows you to post UpdateGrams to SQL Server as updates to the database
providing parameters on input. Think of UpdateGrams as a an XML document
with parameters. You also need to map the XML document structure to the
relational DB structure with an annotated XSD schema. All that is then
required is simple client side manipulation to fill in the parameter values
taken from the XML document sent from your partner and call the Template to
execute the "post".

Thanks.
Mark Fussell
PM - System.Xml

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.
[quoted text, click to view]

dotnet xml : xml to SQL