question

SSRS-VS avatar image
0 Votes"
SSRS-VS asked SSRS-VS commented

How to rename SSRS databases (ReportServer & ReportServerTempDB)?

We have the two DB of our SSRS server: ReportServerTest & ReportServerTestTempDB.
Now we are going to move the SSRS serve to production. For this, we create the .bak of both DB and we restore them in the production-pc SSMS. Then, we link the DB from Report Server Configuration Manager.

We want to rename both DB in order to delete the "Test" part: ReportServer and ReportServerTempDB. I guess we can't just click on the DB and just click "rename" since this two DB have dependency between them. What we must do in order to avoid errors in the DB rename?

If you need to know, our SSRS server has mobile reports. So I think some scripts will not work.

sql-server-reporting-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Joyzhao-MSFT avatar image
0 Votes"
Joyzhao-MSFT answered SSRS-VS commented

Hi @SSRS-VS ,
Rename ReportServer & ReportServerTempDb databases
With an existing SSRS deployment, renaming the ReportServer & ReportServerTempDb databases is not straightforward.

When the ReportServer database is initially created & named, it is created with hard-coded references to the ReportServerTempDb.

121130-01.jpg

Modifying the database name will cause a lot of confusion.

You could refer to: How to Rename Your existing Report Server Database.
Migrate a Reporting Services Installation (Native Mode).
Best Regards,
Joy


If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.



01.jpg (30.5 KiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Then what is the solution?
We can't just create a new one and upload all the reports, datasources and datasets one by one.
I found this script: https://businesswintelligence.com/content/80/ssrs-simple-migration-script
But this cause me a lot of doubts: ssrs_migration.rs will migrate mobile reports? I can use this in local?
Because the powershell script in the url says:

$SOURCE_URL = "https://source-server.com/ReportServer"
$DESTINATION_URL = "https://destination-server.com/ReportServer"

So I don't know If I can made the copy in local. I'm forced to connect to other pc (or create a virtual machine with virtual box)

0 Votes 0 ·