migrate single ssrs report folder

hi

i have old sql server 2008 with reporting service and new one 2012 version

and i need to move single report folder from old server to new server

is there any tool or script can make that possible 

thanks in advance

July 30th, 2015 6:29am

Hi Abdulqader,

It is possible to copy a single folder.

Please follow the below link

https://msdn.microsoft.com/en-us/library/dn531017.aspx?f=255&MSPPError=-2147217396

Free Windows Admin Tool Kit Click here and download it now
July 30th, 2015 8:13am

Hi Abdulqader,

According to your description, you want to migrate a report folder from SSRS 2008 to SSRS 2012, right?

In your scenario, since the source report server is SSRS 2008, you can use Reporting Services Scripter to migrate the report folder. Also you can take advantage of PowerShell Script to achieve your requirement. Based on my research, there is a third party utility called reportsync has migration feature. For more information, please refer to this similar thread: SQL Server Reporting services migration (2008 to 2012).

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu

July 30th, 2015 10:12pm

thank u sir for help Milan Das

but the script keep adding on source server /ReportService2010.asmx and don't find the server

please help what did i do wrong

rs.exe -i ssrs_migration.rss -e Mgmt2010 -s http://server_name/Reports_server_name/ -u Domain\User -p password -v ts="http://TargetServer/reportserver" -v tu="Domain\Userser" -v tp="password" -v security="True"  f="/source_report_folder" -v tf="/destination_report_folder"

Could not connect to server: http://server_name/Reports_server_name/ReportService2010.asmx


Free Windows Admin Tool Kit Click here and download it now
August 2nd, 2015 5:03am

Reporting Services Scripter used to migrate all content of the report server 

reportsync did not work it keep say 404 page not found

and the thread you refer is about migrating all content of the report server 

thanks for trying Qiuyun Yu

best regards,


August 2nd, 2015 5:08am

Hi Abdul,

Please try in below format as shown in below image and please mark as answer if it works for you

Free Windows Admin Tool Kit Click here and download it now
August 2nd, 2015 7:11am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics