Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2003

    Talking Unanswered: SQLServer dbExtender?

    Does SQL Server expose itself as XML? Like db2 Extender for instance.

    WE have some XMl coming in and I have the task of mapping and writing into the db. I think this should be the task of doing an XSLT. Does anyone have a tool recommendation such as Map Force versus XMLSpy or BizTalk?

    Also, is there a standard or discussion of the update strategies. That is, sometimes the updates will over-write, sometime add related records, and sometimes replace. Waht happens depends on the types of data coming in such as "hair color" for a person. Maybe it should over-write or maybe one should be logged as as "disguise" etc.

    Wouldn't handling this be quite hard with XSLT?

    Thanks for any feedback,

  2. #2
    Join Date
    Dec 2002

    Re: SQLServer dbExtender?

    Have you looked at OPENXML in the BOL? It may be what you are looking for. The chief limitation that I have found is that OPENXML won't accepts documents that are larger than 4000 characters (I THINK that's the limit).

    I don't use OPENXML myself. Instead, when we receive XML documents, I have some VBScripts that reaed the XML into the MSXML DOM. I then manipulate and update as necessary. Not very elegant, but it does work.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts