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.

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 (http://blog.sqlauthority.com)

3 thoughts on “SQL SERVER – Migrate a SQL Server Reports from one server to another server

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

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s