What are the challenges you face when working across database platforms? Take the survey

Processing xml report

colinRobinsoncolinRobinson Posts: 13
edited May 13, 2005 1:28PM in SQL Compare Previous Versions
I have run an xml report from the command line of sqlcompare.

if i am processing 100+1 servers i will get 100+xmlreports formatted as servername.xml.

can anyone suggest a method of parsing these files for differences that will identify the Server and object containing the Difference:

ive tried dos concatenate to produce 1.xml+2.xml etc, but thats as far as ive got so far.

some dot net code to read into dataset or sql code to get the data into sqlserver table would be very much appreciated !



  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    Hi Colin,

    I think this could be done using an XSL Transformation template. We use these to produce the HTML report and apparently you can change the output method to text instead.

    If you do it that way, you can conditionally select only the differences and output them into a text file.

    Give me a few days and I think I can come up with a crude .net program that can do this.
This discussion has been closed.