Introduction:
Many cases we need to validate staging and production data. Mostly the client have send only XML files(production) and we have to validate our end output(staging).In this tool, we Validate the schema and compare the datas.
How to start?
- Change the config settings ( refer app.config in the attachment ).
- Set any primarykey is avail for each element ( in app.config - if new create one appsettings , its automatically get from the process)
- Finally the log will bind into the server.( refer errorpath and find out the result )
- Initially its validated Schemas.
- Once schema validated, compare both datas are equal.
- This process will done by using dataset.
Primary Key:
Uniquekey is used to map two files.So You have to add elements in app.config file dynamically based on your requirements.
<appSettings>
<add key="TECH" value="ID"/>
<add key="Positions" value="PID"/>
</appSettings>
Here "key" refers table name and "value" as column name.
Conclusion:
Through dataset we validated and compare the xmlfiles.Its more powerful to validate easily from XML to dataset. In code comments we ellobrate all the functionlity levels clearly.