How many time you have felt that there should be need of the tool which help you to migrate SQL Server Reports from one server to another server. Well, I am glad to see this migration tool for migrating reports from SQL Server 2008 R2 and later version. This tool uses powershell for migration script. Here is the requirement of source server and target server. Source server must be native mode using Windows authentication. Target server must be SharePoint integrated mode. The web application must be using Windows classic authentication mode.
You can migrate it using any of the following methods.
- Command-line tool (RSMigrationTool.exe)
- GUI tool (RSMigrationUI.exe)
Either of the tool will generate a powershell script which will migrate the reports. This tool also generates the log file which provides the additional details regarding the migration.
Here is the link to Download the SQL Server Reporting Migration Tool.
Reference: Pinal Dave (http://blog.sqlauthority.com)