Updating Tables Using a Single Updategram Message in BizTalk Server 2004 and 2006: ASP Alliance

Print Add To Favorites Email To Friend Rate This Article
Updating Tables Using a Single Updategram Message in BizTalk Server 2004 and 2006

page 2 of 8

by Naveen Karamchetti
Feedback

Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 35348/ 44

Article Contents:

What is an Updategram?

An Updategram is a data structure that is used to specify a change in the data in the database tables. INSERT, UPDATE, and DELETE commands are represented in an Updategram by the difference of the image of the data before and the image of the data after a change.

One way to run an XML Updategram is to save the Updategram as a file and then run the file in the URL as a template file.

Sample Updategram

Listing 1 – Sample Updategram

<ROOT xmlns:updg="urn:schemas-microsoft-com:xml-updategram">
   <updg:sync>
      <updg:before>
         <City updg:id="1" Name="HYD"/>
         <City updg:id="2" Name="BGL"/>
      </updg:before>
      <updg:after>
         <City updg:id="1" Name="Hyderabad"/>
         <City updg:id="2" Name="Bangalore"/>
      </updg:after>
   </updg:sync>
</ROOT>

NOTE: All updategram/diffgrams nodes with siblings must have ids, either user specified ones or mapping schema based key field id.

« (Page 1)

View Entire Article

(Page 3) »

User Comments

Title: Insert in to multiple tables at a time.
Name: Umesh
Date: 2008-11-27 8:20:12 AM
Comment:
Hi ,
I want to insert data in multiple tables at a time (like header and details ) .
for this purpose i am using Updategram.How can i generate schema for this purpose.

umesh.chpe@gmail.com

Title: Getting invalid namespace error with above sample
Name: Krishna Sharma
Date: 2007-12-04 6:37:55 AM
Comment:
I am getting "Invalid Schema" error in the send port while inserting data. any help..If you have sample code .plz send

Title: How to update multiple tables
Name: Gopal
Date: 2007-11-26 10:54:19 PM
Comment:
Above information only tells how to insert into multiple tables, I am trying to update multiple tables could not succeed... I did not find any information on updating multiple tables....

Error

Error details: HRESULT="0x80004005" Description="All updategram/diffgrams nodes with siblings must have ids, either user specified ones or mapping schema based key field id"

Can some one point me in right direction...

Thanks in advance
Gopal

Product Spotlight