Post reply

Compare contents of two XML files

  • 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 6 years ago by gana79950.

  • September 28, 2019 at 11:16 pm

    #3684338

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

  • September 30, 2019 at 3:00 pm

    #3684595

    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

  • September 30, 2019 at 3:56 pm

    #3684624

    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.

  • September 30, 2019 at 4:01 pm

    #3684634

    gana79950 wrote:

    Please advise.

    Advise what, exactly?

  • September 30, 2019 at 4:13 pm

    #3684647

    script to compare one field value in two xml files.

  • September 30, 2019 at 4:54 pm

    #3684660

    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.

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

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