• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 327
  • Last Modified:

Moving/Deploying my Reporting Services Project to a remote server

I created a Reporting Services project on my local machine,
The data source, and database that the reports use/access are on
a remote SQL Server (Lets call it Server XYZ)

So here is my question. How shall I deploy these reports
to the SQL server Server machine "XYZ", from my local machine? Can I simply copy them to the
same directory structure on the remote server that hosts the Reporting
services projects? Because basically my local directory structure for the
reports mimics the location of those  Reporting Services projects on the server:

C:\Documents and Settings\AV_KP_Admin\My Documents\Visual Studio 2005\Projects\.....
0
brgdotnet
Asked:
brgdotnet
  • 2
  • 2
1 Solution
 
Chris LuttrellSenior Database ArchitectCommented:
You deploy reports to the reporting server, see http://msdn.microsoft.com/en-us/library/ms345236.aspx for some how-to topics on Publishing reports
0
 
brgdotnetAuthor Commented:
Actually I just moved the Reporting service project from my local machine to the server. I placed it in the same directory structure. I then opened it up built and deployed it. It worked great. I did not read the article you posted though. I will read it later.
0
 
brgdotnetAuthor Commented:
Average response.
0
 
Chris LuttrellSenior Database ArchitectCommented:
Yes, you can copy it and build it again, we have done that in the past.  But what if you have a producion server that they refuse to allow the tools be loaded on for security reasons.  Or what if the directory structure is different.  Or if you have multiple servers to deploy to, do you want to have to copy to each and log on and build the reports again.  Using the deployment tools and configuration manager, we can build locally for development and then deploy to multiple servers for Production, QA, Training etc.  It is just good to learn what tools are available and how to use them, especially in stricter environments.  Not trying to be mean, just trying to explain why I steer folks away from the old "I'll just copy everything" approach.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now