February 16, 2018 at 11:30 am
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
February 16, 2018 at 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?
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
February 16, 2018 at 1:28 pm
jonathan.crawford - Friday, February 16, 2018 11:37 AMyou 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
February 16, 2018 at 5:29 pm
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
February 19, 2018 at 12:04 pm
jonathan.crawford - Friday, February 16, 2018 5:29 PMAsk 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?
February 19, 2018 at 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/
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
February 20, 2018 at 4:48 pm
jonathan.crawford - Monday, February 19, 2018 2:59 PMnot 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.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy