Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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...:(
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.