February 2, 2006 at 12:50 am
Hi all,
we have an development-server, an integration-test-server and and production server. which is the best way to transfer reports, I preveously published to the integration-test-server, to the production-server? I donn't have access to the production server. A third person, who is administrator for this server, but he doesnt know anything about sql-server, must be able to do the transfer...
regards
ralf
February 2, 2006 at 5:43 am
the simplest way is to go on the reporting services home page and then click on the project folder, click on upload file and then do the upload.
the simplest long term is to write a program that automates the transfer on the files and the datasources in one go
if you installed the rs samples they give you a head start. goto C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\Samples\Applications\RSExplorer
choose either vb or c#, you might need to tweak it a bit
February 2, 2006 at 6:58 pm
If you're system admins are OK with command line tools, then rs.exe could be the way to go. The following is straight from the RS BOL. Type rs.exe into the index and then select the "Repiort Server Command Line Utilities" sub heading.
Cheers,
Steve.
Scripting Deployment and Administrative Tasks
Using scripting, developers and report server administrators can easily and efficiently perform repetitive tasks on a report server, or duplicate work from one computer to another. You can use scripting with Reporting Services in the following ways:
Automate Repetitive Tasks
Repetitive tasks suitable for scripting include things such as finding all reports being delivered to a recipient or department, and doing a globally modifying the recipient or department. Scripts can also do tasks such as cancel jobs that are currently running. For an example of a script that can cancel jobs, see Script for Canceling Running Jobs.
Duplicate an Environment and Settings to Another Server
Use scripts to move reports and their settings from one server to another. You can write a script for the report server and report server database, which contains information about report definitions and executions settings. You can then run this script on another server to re-create the reports and all saved settings. If you have multiple report servers in your deployment, you can run the script on each server individually to configure all servers in the same way.
Migrate from Development Computer to Test Environment, and Then Migrate from Test Environment to Production Environment
Use scripts to copy the settings of a report to multiple report servers. You can set properties on one report, and then save the settings in a script file. You can then run this script against other reports to make their properties identical. You can also use scripts to do tasks such as import and subsequently export a report and all of its properties to another machine. This type of tool is useful if you need to persist properties outside of the catalog, such as keeping the version control set on a report when moving reports between a development, test, or production computer. The following list describes the steps required to do this task using scripting support.
Set your script variable to the URL of the source server.
Use GetReportDefinition Method and GetProperties Method to retrieve the report definition and the properties of the report.
Set the URL to point to the destination server.
Use CreateReport Method, passing the properties returned from GetProperties and the report definition returned by GetReportDefinition.
If you create scripts, the script runs under Windows Authentication unless credentials are explicitly set. For more information about script samples installed with Books Online, see Sample Scripts. For more information on how to format and run a script file, see Scripting with the rs Utility and the Web Service.
Steve.
February 2, 2006 at 7:00 pm
Forgot to emntion, theres also a sample script that publishes the sample reports to the RS server. You could easily mod this to publish your production reports as a first step.
Steve.
February 3, 2006 at 12:50 am
thank you, bledu. I think we willl do it your way. thank you also, steve - where can I find the sample script that publishes the sample reports to the RS server and what is its name?
ralf
February 3, 2006 at 4:31 am
It should be in your samples directory (under the RS installation directory). Also check out Books On Line, it has descriptions of the samples as well as details on where to find them.
Steve.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply