Compare contents of two XML files

Question

Compare contents of two XML files

gana79950

Old Hand

Points: 371
More actions
September 28, 2019 at 11:02 pm

#3684336
Hi,
I have to compare XML contents in column A in Table A in Database A with XML contents in column B in Table B in Database B.
Basically I want to see if the contents of XML files equal or different.
Can please provide me a sample SQL Query to achieve this ?
Thanks,
- This topic was modified 5 years, 1 month ago by gana79950.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246960 More actions · Answer 1

Can you provide sample DDL and data, please? In the form of INSERT statements.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

drew.allen SSC Guru Points: 76985 More actions · Answer 2

You also need to specify what you mean by "equal or different". XML files can contain exactly the same information, but have a slightly different layout. Are they equal because they have the same information or are they different, because they have a different layout. For example

<person>
   <first>James</first>
   <last>Bond</last>
</person>

and

<person>
   <last>Bond</last>
   <first>James</first>
</person>

are semantically equal, but have different layouts.

Also, XML is case-sensitive. Does that matter for your purposes?

Drew

J. Drew Allen
Business Intelligence Analyst
Philadelphia, PA

gana79950 Old Hand Points: 371 More actions · Answer 3

May be I will first try comparing one field value, which I know it should be there if the are for same transaction.

Please advise.

Phil Parkin SSC Guru Points: 246960 More actions · Answer 4

gana79950 wrote:

Please advise.

Advise what, exactly?

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

gana79950 Old Hand Points: 371 More actions · Answer 5

script to compare one field value in two xml files.

Phil Parkin SSC Guru Points: 246960 More actions · Answer 6

gana79950 wrote:

script to compare one field value in two xml files.

Can you provide sample DDL and data, please? In the form of INSERT statements.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin