Data comparison between XML and SQL server

[rajeshbijlani]

I want to make sure that the data from the XML file is loaded successfully in SQL server database.

So I have to do the following:
1> Extract data from the XML file and put in a csv file.
2> Execute a query on sql server2000 datadabe and output the results in a csv file.
3>Compare the data from the 2 files and validate that the data matches.

I want to create a batch file to do that.
Can I use awk/sed scripting for doing that? If yes does anybody have a ready script that I can use? If not can anyone guide me on how I can achieve that?

 

[PHV]

If the batch file should run in a windows environment I'd play with Recordset in VBScript.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886