<div>
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?
</div>


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?

<div>
You could have a SQL Job that excutes the script on a schedule.
</div>


You could have a SQL Job that excutes the script on a schedule.

<div>
Is it possible to Deploy the RDL files to different locations using SQL Jobs? How to do that.
</div>


Is it possible to Deploy the RDL files to different locations using SQL Jobs? How to do that.

<div>
Have a look at this example:<br />
<br />
Script for Publishing Sample Reports<br />
<a href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_1apd.asp" rel="ugc nofollow">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_1apd.asp</a>
</div>


Have a look at this example:

Script for Publishing Sample Reports
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_1apd.asp [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/rsamples/htm/rss_sampleapps_v1_1apd.asp]

<div>
<div class="content wysiwyg-content">
Hi,<br />
&nbsp; &nbsp; 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.<br />
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?<br />
<br />
thanks,<br />
maran
</div>
</div>


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

Deploy Reporting services to multiple remote servers

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.