Move Reporting Services Reports from one SQL Server to Another

Here are the steps I used to move SQL Reporting Services reports from one server to another:

Create New Data Source:

  • Go to the folder where your current report exists.
  • Click Show Details located in the menu bar on the right.
  • Open the Data Source on the old server by clicking the Edit icon next to the Data Source
  • Open a Second Internet Browser window and go to your new SQL server with Reporting Services.
  • Create a Folder structure that mirrors the Folder structure on the older SQL server.
  • On the new SQL server, drill down to the same folder as the one you have open on the old server.
  • Click New Data Source on the menu bar.
  • Copy and Paste the information fields from the old server Data Source page to the new server. Click OK when you are done.

Copy the Reports:

  • Go to the folder where your current report exists.
  • Click Show Details located in the menu bar on the right.
  • Click on the Edit icon next to the report you wish to copy.
  • Under Report Definition Click Edit.
  • A File Download screen will appear. Save the file to a temporary folder.
  • On the new SQL server, drill down to the same folder as the one you have open on the old server.
  • Click Upload in the menu bar.
  • Click Browse and go to the file you saved in the previous step.
  • Click OK to upload the report file.
  • The report should now show up in your list.

Re-linking Report to Data Source on New SQL Server

  • Before the report will work, it must be re-linked to the new data source on the new SQL server.
  • Click the Edit icon next to the new report.
  • Click Data Sources on the menu on the left of the screen.
  • Click the Browse button and browse to the Data Source you created earlier. If you are uncertain as to which Data Source to use, go back to the old SQL server and look at the old reports settings.
  • Click OK, test by opening the report.

6 comments for “Move Reporting Services Reports from one SQL Server to Another

  1. srini
    May 5, 2010 at 3:17 am

    it helped me.
    but, how to move reports from higher version sql server like sql server 2008 to lower version sql server like 2005/2000

  2. Bam Willis
    May 25, 2010 at 10:38 am

    This is not working for me. The only information available in the data source table that is copy/paste-able is the data source which just looks like a connection string. I am attempting to move an .rdl (and associated database data) to a differently named server. I do not want the new report to look back to the old database(in this cast my local one). I am looking for a way to deploy reports from our internal development servers to our clients production servers.

    Am I missing something?

    • May 25, 2010 at 10:53 am

      Bam,
      I am going through the steps that I have listed above. I’m not able to exactly replicate the process because the old SQL server is now retired.

      In reading your comment again, my first question is, has your database data already been moved to the new location? The instructions above assume the database has has already been copied to the new SQL server. The instructions only move the reports and then point the reports to the new SQL server.

  3. July 26, 2011 at 10:51 pm

    Take a look at this tool that will copy reports or whole folders from a source server to destination server.

    http://code.google.com/p/reportsync/

    It will also attach the datasources if they have the same name on the destination server.

  4. Amy
    February 2, 2012 at 10:21 am

    I don’t understand the phrase “clicking the Edit icon next to the Data Source”. Where are you seeing the datasource file at this point? When I use explorer and get to the file where the data source file is located there isn’t an Edit icon next to it? Can you explain where you are are at when you see this icon? Please

    • February 2, 2012 at 10:26 am

      Using Internet Explorer, go to the report you are interested in editing. Once you can see the report(s) in the menu bar of Reporting Services on the right side you should see, Show Details. Click it and it will list your reports with details. In the details you should now see an Edit icon.

      Let me know if you still have issues.

Leave a Reply

Your email address will not be published. Required fields are marked *


*

Subscribe without commenting