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 (https://blog.sqlauthority.com)
Also, here is a good tool which explores the performance and the usability of your reports:
Before migrating, you might just look at the performance, and which ones are used and how.
Quite useful Pinal. Thanks for sharing.
Unfortunately it still does not have support for migrating to Native Mode but in the Download Center, they mentioned they are working on the support for Native Mode. Hoping to get the support for Native Mode Soon.
your any blog on “Differences between sql 2000,2005,2008 and 2012”
please post on Face Book