March 22, 2016 at 4:18 pm
We need to upgrade SSRS report server to another new server with SQL 2014.
For about 100 reports the developer uses the parameter for database source.
It passes connection string from application to SSRS report.
But in report manager, parameter, there is a default value there with the server name:
Source=myservername;Initial Catalog=mydb;Integrated Security=True
Now when we upgrade and migrate to the new server, the server name needs to change to new name, but it is a lot of work to change one by one in report manager for the parameter default values.
Is there a way to batch change the server name in the parameter default values?
I looked at the database - reportserver, in the dbo.catalog.parameter, it seems data stored there.
But that is a ntext field. Replace function not work for ntext, needs to change it to nvarchar(max) then back to ntext to do a replace string function. This is a system database, I am a little nervous to update this way.
Any other safe options?
Thanks
March 23, 2016 at 3:57 am
Technically speaking, the ReportServer database is not considered a system database. I personally consider SSRS similar to other "third-party" applications that use a database schema that I have no control over and application code that I cannot see. For all those databases, I am always hesitant to modify table contents directly because I do not know if the application normally updates some other data at the same time.
But sometimes a DBA's gotta do what a DBA's gotta do, and in that case being careful is important. I have never modified parameters in SSRS directly, but I have done comparable things if I had to. In your case, I would start by making a small test report that uses the same parameter, then writing the UPDATE statement with a WHERE clause to touch only that report and see if it still works after the update. If it does, then take an extra backup of the ReportServer database, store it somewhere safe, and then take the leap.
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply