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