SSRS Reportserver parallel testing

Question

SSRS Reportserver parallel testing

ddaccount

SSC Rookie

Points: 47
More actions
February 16, 2018 at 11:30 am

#333600

Is there a way to run all reports on server 1 and server 2 and compare the results. So run each report with designated parameters on each server and have results go to either a single file or 1 file per report . PDF, excel or other format. The goal is to use a tool like beyond compare or Visual studio to quickly identify discrepancies.
Thanks,
Dave

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

jonathan.crawford SSCertifiable Points: 6610 More actions · Answer 1

you want to run them on the reportserver, or could you just run the stored procs that are feeding the reports and compare that way?

-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

ddaccount SSC Rookie Points: 47 More actions · Answer 2

jonathan.crawford - Friday, February 16, 2018 11:37 AM
you want to run them on the reportserver, or could you just run the stored procs that are feeding the reports and compare that way?

So to clarify, run all Reports on the reportserver in some sort of cmd file or some other batch mechanism and direct output to a file or files. SSIS can run in batch mode via command utility. Does SSRS have anything comparable?

Unfortunately some of the datasets aren't SPs, rather inline sql. So running in native SQL is not an option. Has to be on ReportServer. Conversion project, old 2008 R2 legacy that needs to be upgraded and no time to create new SPs for inline SQL datasets.

We don't have UAT testing group or any testing automation tool and we don't have time to visually verify.. Looking for creative handcrafted automation.

Hope this added info helps.

Dave

jonathan.crawford SSCertifiable Points: 6610 More actions · Answer 3

Ask the end users to help verify, distribute the workload

-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

ddaccount SSC Rookie Points: 47 More actions · Answer 4

jonathan.crawford - Friday, February 16, 2018 5:29 PM
Ask the end users to help verify, distribute the workload

Again great ideas but we do not have the resources nor does the business. Plus the business doesn't care that we are converting to 2016. IT governance mandated project. Not looking for business logistics solution.

Can this thread be redirected to a different forum or is better to re-post the question to different forum?

jonathan.crawford SSCertifiable Points: 6610 More actions · Answer 5

not exactly what you are doing, but might be helpful: https://morecomputerstuff.wordpress.com/2015/05/20/running-batch-ssrs-sql-server-reporting-services-reports-using-powershell/

-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses

ddaccount SSC Rookie Points: 47 More actions · Answer 6

jonathan.crawford - Monday, February 19, 2018 2:59 PM
not exactly what you are doing, but might be helpful: https://morecomputerstuff.wordpress.com/2015/05/20/running-batch-ssrs-sql-server-reporting-services-reports-using-powershell/

Thanks, I'll take a look.

I also got some a hold a SSIS package with a script task that loops thru SSRS metadata and saves the rendered report to an excel download. I'll taken look at that.