Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Comparing application deployed in two different servers.

Hi All,

We have all our QlikView applications deployed in a new server which were residing in the old server. I just need to check the deployment is successful, i.e the applications in the old and new server are same and contain same data. Is there any way to do it using any kind of script. Or to what extent I can automate this process.

21 Replies
Anonymous
Not applicable
Author

I don't need to compare the GUI objects marcus_sommer‌, I used a PowerShell script to create -prj folders for each of the .qvw and then opening and closing and the comparing the XML in the -prj gives me the GUI diffs. Now I only need to compare if the data is matching... Or at least the number of rows of each table matches...:(

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Is checking the base QVDs that go into each QVW ok as well? There is a script function called QvdNoOfRecords() that returns the number of rows in a QVD without even opening the embedded table (the function reads the xml header). With a FOR EACH loop and some path variables it should be possible to check table row counts in different environments and compare them table-by-table. You can also create an advanced version that loads all tables, and counts discrete values or aggregates values based on field type attribute values.

Just an idea.