Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Deploy Reporting services to multiple remote servers

Posted on 2006-06-15
8
Medium Priority
?
744 Views
Last Modified: 2006-11-18
Hi,
    I have a question. I need to deploy reports to multiple locations. The basic operation is where, i create reports at my client PC using VS.NET.
When i deploy the report, it should be deployed in multiple servers. Is there a way, this can be done? Also, is there any way of maintaining previous versions of RDL files?

thanks,
maran
0
Comment
Question by:thirumaran
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
8 Comments
 
LVL 14

Accepted Solution

by:
simon_kirk earned 1000 total points
ID: 16941026
VS.Net will only deploy to one server, so your probably best off creating a script to copy the report RDL to the various locations it needs to go to.
0
 

Author Comment

by:thirumaran
ID: 16965357
Is it possible to automate the process of copying the scripts to various locations? I know, i need to do scripting. But, i want to know, how can one automate this process of copying the RDL files or deploying the RDL files to different servers?
0
 
LVL 14

Expert Comment

by:simon_kirk
ID: 16966603
You could have a SQL Job that excutes the script on a schedule.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 

Author Comment

by:thirumaran
ID: 17007639
Is it possible to Deploy the RDL files to different locations using SQL Jobs? How to do that.
0
 

Author Comment

by:thirumaran
ID: 17007644
Is it possible to Deploy the RDL files to different locations using SQL Jobs? How to do that.
0
 
LVL 14

Expert Comment

by:simon_kirk
ID: 17007735
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

1. Set up your parameter at the report level as usual, check the box Multi-value, and set the Data Type to String 2. Set the Stored Procedure Parameter to varchar(max)  --<---- This part here is the key to it's success Example:    @cst_key var…
How to increase the row limit in Jasper Server.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Screencast - Getting to Know the Pipeline

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question