SQL SERVER – Migrate a SQL Server Reports from one server to another server

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.

SQL SERVER - Migrate a SQL Server Reports from one server to another server reportmigration

You can migrate it using any of the following methods.

  1. Command-line tool (RSMigrationTool.exe)
  2. 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)

SQL Reports, SQL Utility
Previous Post
SQL SERVER – Identify Columnstore Index Usage from Execution Plan
Next Post
SQL SERVER – Four Tutorial for SQL Server 2012 New Features

Related Posts

3 Comments. Leave new

  • 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.


  • Dattatrey Sindol (Datta)
    May 11, 2012 6:37 pm

    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


Leave a ReplyCancel reply

Exit mobile version