Comparing application deployed in two different servers.

[Anonymous]

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.

[Anonymous]

stalwar1‌hic‌loveisfail‌ can someone guide me on this

[Anil_Babu_Samineni]

I am not good in Server. I may offer you few ways which i done. But, This information quiet not sufficient as i feel. If you have 2 IP's to check those you can cover up and check in Access point only. Or not please explain more in detail

[Anonymous]

Thanks Anil for response, I can check manually in access point of both servers. But there are too many reports and each with obviously numerous sheets... so am looking for any kinid of automated script, that can compare the application in both servers. If i have to check beofre deployment to server, we can get the xml files of the .qvw and compare. But am not sure how it can be done after deployment, through access server... may be comparing the html code or something......

[Anil_Babu_Samineni]

I am afraid, Whether there is any such code. Let's wait while response from them marcus_sommer‌punitpopli‌

Try this Batch Script

If

"C:/Program files/Qlikview/qv.exe" /R "D:/A.Qvw" : eof : insert

"C:/Program files/Qlikview/qv.exe" /R "D:/B.Qvw" : eof : insert

"C:/Program files/Qlikview/qv.exe" /R "D:/C.Qvw" : eof : insert

"C:/Program files/Qlikview/qv.exe" /R "D:/D.Qvw" : eof : insert

Then

Trace "First IP Address server is Executed";

Else

"C:/Program files/Qlikview/qv.exe" /R "E:/A.Qvw" : eof : insert

"C:/Program files/Qlikview/qv.exe" /R "E:/B.Qvw" : eof : insert

"C:/Program files/Qlikview/qv.exe" /R "E:/C.Qvw" : eof : insert

"C:/Program files/Qlikview/qv.exe" /R "E:/D.Qvw" : eof : insert

Then

Trace "Second IP Address server is Executed";

- Try this and let me know

[Anonymous]

Anil, Can you please explain what this script does??

[Anil_Babu_Samineni]

It run as If First server path runs then execute meantime show the message and same as else code.

I am not sure, whether it will run for your case. Usually, This script proves only for Dependency of applications. Wait some time they will respond you surely

[Anonymous]

Ok Anil, am not sure if this is correct but

as per my knowledge, Accesspoint reads the files from the source document folders located somewhere in the drives of the server. how about reading the files from the folders from both the servers as XML and comparing them??

[marcus_sommer]

I don't think that there are any public tools available with them such automated comparing could be done. Whereby the logic to build such tools aren't very difficult but it will need some time and efforts to create a stable solution. On one hand you need to build a tool which read the tables and fields with their number of records and fieldvalues and then a routine which exported each object from both deployments with multiple selections into an excel-sheet and within them is a further area which checked which cells does have a content and are they identically.

To the methods of both approaches you will find various postings here in the community which could be adapted to this requirement. I think you will need a quite large environment to check or you presumed that this kind of task comes more often and/or a very high degree of accordance between the environments is needed to justify these efforts compared with a manual checking of the most used and/or most important KPI's.

- Marcus

[Anonymous]

Hi marcus_sommer, thanks for the response. so i need to compare the data and then each object in each sheet. Can you please provide some links to make a start. am unable to find any relative information.

And can you please share your thoughts on this

"Accesspoint reads the files from the source document folders located somewhere in the drives of the server. how about reading the files from the folders from both the servers as XML and comparing them??"