RE: Persisted ADO Recordset XML File Manipulation

From: Kevin Yu [MSFT] (v-kevy_at_online.microsoft.com)
Date: 10/23/04 

Date: Sat, 23 Oct 2004 09:28:28 GMT

Hi Olivier,

First of all, I would like to confirm my understanding of your issue. From
your description, I understand that your column names in the xml and
database are different from each other, and you need to know how to update
it to the server. If there is any misunderstanding, please feel free to let
me know.

As far as I know, using XSLT is a simple way to achieve that. The first
part of the Xml is schema information, the second part is data. We have to
change both the names in schema and data elements, so that it might work
properly.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Relevant Pages

  • Re: Persisted ADO Recordset XML File Manipulation
    ... I do not have much time to investigate XSLT. ... > part of the Xml is schema information, ... > change both the names in schema and data elements, ...
    (microsoft.public.data.ado)
  • Re: DISCOVER_XML_METADATA
    ... expansion of ASSL XML returned by the server. ... You could do ExpandObject for the server in step 1. ... you could request ExpandObject for that database -- this is step ... all cubes and nothing else. ...
    (microsoft.public.sqlserver.olap)
  • Re: Preservation of namespace prefixes in XML datatype
    ... representation well beyond merely preserving the logical meaning. ... > Now the ANSI/ISO SQL-2003 standard makes it pretty clear that the XML ... all the guarantee the database gives you is that we preserve the ... >> makes changes in namespace prefixes, will I the user/developer have the ...
    (microsoft.public.sqlserver.xml)
  • Re: Wanted:MAIL.MAI structure definition
    ... a relational database is more flexible in the retrival of data. ... Perhaps this impact has been softened as hardware has gotten faster, but, overhead is overhead, and if you weren't using the advances in hardware for overhead, those designs that have less overhead would also gain from the faster hardware. ... RFC822 header because your XML parser wouldn't be able to understand new ...
    (comp.os.vms)
  • Re: Rework [Was: Static vs. Dynamic typing...]
    ... Agile projects have an extraordinarily low chance of a big change. ... Suppose you start with XML files, and by Iteration 6 the ... Switching to a database is now cheaper than morphing XML files into a ...
    (comp.object)