This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(144, 38%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECG%3C/text%3E%3C/svg%3E)
Hi Guys,
Thanks for any answers in advance.
Overview of project
We have an existing SQL 2016 server and have built a new SQL 2019 server. We want to move the report from SQL 2016 to SQL 2019. I actually completed this using a mixture of RS.exe and the ReportSync tool. The issue is that all the data sources need to be manually updated for the new SQL server.
What I am wondering is if there is a method of connecting Visual studio 2019 to the SQL 2019 SSRS server. Download all the reports, then update their data source and redeploy. I do have Visual Studio SSRS extension installed and can push a new report, but I can't see how to view existing reports on the SSRS server. Maybe it's not possible, and Visual Studio can only be used for deploying.
Can someone let me know if it's possible and who to do it? else am I just wasting my time.
Regards
Craig Garland
Don't you have the SSRS 2016 SSDT project with all reports?
Then open the project in new SSDT for 2019, change the TargetServerVersion to 2019, build the project and deploy it.
Hi Olaf,
Thanks for the response. Maybe I should have mentioned that I am not a coder and don't use Visual Studio or SQL much at all. The original report were developed using SQL Report Builder, and SSDT was not used.
Am I able to setup the SSDT to the new / old SQL and list reports, then update data sources? Note I have copied all the reports to the new 2019 SQL server; I just need to update the data sources, which could be done manually, but I am sure there is a better way.
Do you have a link to a tutorial that might help me set this up? or any other advice?
Thanks in advance
Craig
Note I have copied all the reports to the new 2019 SQL server
That's fine and the best base for a solution. Start SSDT, create a new BI Reporting Service project. Ricght-mouse click on the project folder ="Add existing item" and add each existing report to the project. Some project settings and the job is done; you can deploy the solution to SSRS.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi @Craig Garland I found a thread about updating data sources in batches, maybe you can use it as a reference: https://learn.microsoft.com/en-us/answers/questions/142161/ssrs-bulk-update-custom-data-source. Best regards, Aniya
Hi Thanks for the information. I did try the select statement from that script, which did not work. I'm not sure the script would work anyway, as I have two DataSource's that need updating. It also does not answer the question of connecting Visual Studio to an existing SSRS to review and update reports. I get the feeling that this is not possible and that Visual Studio can only be used to create and upload existing RDL reports. Not to view and edit reports already created in SSRS. Do you think that is correct? Craig
Hi @Craig Garland Based on my search, Report Designer can browse the computer for local paginated reports. You can refer to this document: Find, view, and manage reports. Regards, Aniya