DiffGrams equivalent for Oracle servers ?? -- dotnet datatools

lab
12/16/2004 12:25:09 PM

Hi.

I understand that the DiffGrams feature in ADO.Net allows you to specify an
xml document and a mapping schema, and once these are declared, ADO.Net will
update the required tables using the mapping schema to determine what field
to update with the data that is contained in the XML document. My
understanding is that this feature is only available when using a SQL server
2000 database. I am looking for this type of functionality for use with an
Oracle server.

Does anyone know of a similar feature that can be used with an Oracle server ?

Andrew Conrad
1/21/2005 5:25:01 PM

No. Oracle does not really have a mechanism for declaritively representing
changes to Xml.

You can set your Oracle databases up as linked servers to your Sql Server
and run the diffgrams against the Sql Server.
Andrew Conrad
Microsoft Corp

[quoted text, click to view]

dotnet datatools : DiffGrams equivalent for Oracle servers ??