Processing xml report
colinRobinson
Posts: 13
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 !
colin
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 !
colin
This discussion has been closed.
Comments
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.