Hello:

I was wondering what a typical DBA needs to know about
installing, configuring, and more importantly, supporting
SQLXML 3.0

I have no experience with SQLXML and one of our vendors
has asked me to install SQLXML 3.0 to our DEV SQL server.

I've done some reading in Microsoft's MSDN website -
http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnanchor/html/anch_SQLXML.asp. I'm
trying to gather more information on this tool/utility.
Any additional information on this would be a great help.

Thanks.

SQLXML (any version) is part of a the mid-tier/client and thus is installed
where you normally have MDAC installed (ie the client or webserver machine
and not on the database server per se).

HTH
Michael

"Rob" <anonymous (AT) discussions (DOT) microsoft.com> wrote

In addition to Michael's comment. Here is the list of main technologies
offered by SqlXml 3.0:

Annotated Schemas: Allows you define mapping between a virtual Xml document
and the tables/views in Sql Server.

XPath over Annotated Schemas: Translates the XPath over the virtual Xml
document to a For XML query on the Sql Server by using Annoated Schemas.

Updategrams/Diffgrams: Serializes the changes in your Xml Document to the
Sql Server by using CUD operations by using the mapping defined Annotated
Schemas. Updategrams also works by using a default mapping without using
Annotated Schemas.

Bulkload: Fast loading big sizes Xml to the Sql Server using Annotated
Schemas.

There are a lot more like Templates, ClientSideXml, SqlIsapi and Xml
WebServices. Please, refer to the SqlXml30 documentation for more details.

Thanks.


"Rob" <anonymous (AT) discussions (DOT) microsoft.com> wrote