Does anybody have any projects or insight on upgrading the SQL Server source databases to 2017 and still use existing SSRS 2012 .rdl files?

sqlagent007
sqlagent007 used Ask the Experts™
on
Does anybody have any projects or insight on upgrading the SQL Server source databases to 2017 and still use existing SSRS 2012 .rdl files? We need to upgrade our OLTP environment and do not currently have enough SSRS report developers to get the SSRS part done by the due date. Our thought was to leave the current .rdl files at 2012 revision level and just upgrade the OLTP source database to 2017. We will not be upgrading the SSRS databases or the SSRS engine.

Thanks experts!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
If all your SSRS reports (rdc/rdlc files) used shared-datasource(s) instead of embedded-datasource then you would only need to change shared-datasource(s), and deploy it to your SSRS server(s).

Worst case scenario, you change the shared-datasource in your project, rebuild to see if you get errors (I doubt you will get errors), and deploy the shared-datasource.

Want to be lazier, just go on the SSRS server, alter the shared-datasource(s), and test some reports.
sqlagent007Technology professional

Author

Commented:
Thank you!!!!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial