Migrationg SSRS

How to migrate SSRS from Onprem to Azure VM.

Details:
OnPrem--> SSRS 2008
Azure--> VM SQL Server 2016
VijayAsked:
Who is Participating?
 
Pushpakumara MahagamageVPCommented:
if you have source code. best thing is deploy reports to Azure VM again.

other wise you can restore your data source database and reportserver database to Azure VM and restore/recreate encryption key from Report configuration manager.

see instruction in following link.

https://www.mssqltips.com/sqlservertip/2692/migrating-sql-reporting-services-to-a-new-server-by-moving-the-reporting-services-databases/
0
 
Gaurav SinghSolution ArchitectCommented:
There is no such standard process for this. Process is same as we do in On Prem Migration. you just need to make sure that your On Prem SQL and Azure VM are in network connection communicating with Each other. Below link might give you an Idea:

http://www.jamesserra.com/archive/2016/05/migrate-from-on-prem-sql-server-to-azure-vm-iaas/
0
 
VijayAuthor Commented:
Hi Pushpakumara,

If i follow  below link i need not to migrate .rdl files, i am i correct?

https://www.mssqltips.com/sqlservertip/2692/migrating-sql-reporting-services-to-a-new-server-by-moving-the-reporting-services-databases/
0
 
Pushpakumara MahagamageVPCommented:
Yes you are correct, you don't have to upload RDL files.
0
 
VijayAuthor Commented:
Thank you Pushpakumara
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.