Bryant Likes's Blog

It's all about WebData

Recent Posts

Tags

News


  • Windows Live Alerts
    View Bryant Likes's profile on LinkedIn

    Me

    The posts on this weblog are provided "as is" with no warranties and confer no rights. The opinions expressed herin are the personal opinions of the individual authors and do not represent the views of Avanade in any way.

Community

Email Notifications

Archives

SqlXml 3.0 Sp2 Released!

This is something that many people have been waiting for. It was posted yesterday in the newsgroups but I missed it since the MS news servers were having problems.

I'm happy to announce that the RTM version of SqlXml 3.0 SP2 has been
released!

You can download the bits from:
http://www.microsoft.com/downloads/details.aspx?FamilyID=4c8033a9-cf10-4e22-8004-477098a407ac&DisplayLang=en

SP2 includes many fixes since the SP1 release including:
  a.. Identiy Propagation for XML Bulkload
  b.. Null Support for Web Services when used with Visual Studio .NET 2003
Please see the included documentation for details.
Overview
SQLXML enables XML support for your SQL Server Database. It allows
developers to bridge the gap between XML and relational data. You can create
XML View of your existing relational data and work with it as if it was an
XML file. SQLXML allows you to:

  a.. Build Web Services with SQL Server 2000
  b.. Build Web sites to publish data from SQL Server
  c.. Query relational database with XPath
  d.. Update relational data as if it was XML
  e.. Load XML into SQL Server
  f.. Query SQL Server via URLs, OLEDB/ADO or .NET Managed Classes


Thanks!
Irwin Dolobowsky
Program Manager, SqlXml

Now we just need to get some managed classes that don't use the COM Interop.

Posted: Oct 02 2003, 08:54 PM by bryantlikes | with 2 comment(s)

Comments

TrackBack said:

SqlXml.org Home Page
# October 3, 2003 8:11 AM

bryantlikes said:

Hi,
I am using Bulkload to upload multiple relational tables, one table with Autoincrement PK. It worked fine. Now I need to Add a child table to it which has the Same PK field and has to be loaded from the parent.

Here I have scores table, whose Score_ID feild is autogenrated. I need to populate another TblScoreHistory table with scoreID and omr_scores fields. I tried with the relationship specifiled but didn't work. How do I define my Schema.

Thanks


MY datafile
<Score editflag="0">
<omr_score>*</omr_score>
<ScoreHistory>
<OrigScore>*</OrigScore>
</ScoreHistory>
</Score>



-------------------------

My Schema
<sql:relationship name="ScoresScoreHistory" parent="scores" parent-key="score_id" child="tblScoreHistory" child-key="ScoreID"/>

<xsd:element name="Scores" minOccurs="0" sql:is-constant="true">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="Score" minOccurs="0" maxOccurs="unbounded" sql:relation="scores" sql:relationship="BookletPageScores" sql:key-fields="score_id">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="score_id" type="xsd:integer" minOccurs="0"/>
<xsd:element name="omr_score" type="xsd:string" sql:field="omr_scores"/>
<xsd:element name="ScoreHistory" minOccurs="0" sql:relation="tblScoreHistory" sql:relationship="ScoresScoreHistory" sql:key-fields="score_id">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="scoreid" type="xsd:integer" minOccurs="0" sql:field="scoreID" sql:mapped="true"/>
<xsd:element name="OrigScore" minOccurs="0" sql:field="vcscanvalue" sql:mapped="true"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
# January 16, 2004 1:19 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)