all groups > sql server reporting services > november 2006 >
You're in the

sql server reporting services

group:

moving reports to another server



moving reports to another server MS newsgroup
11/8/2006 3:35:03 PM
sql server reporting services: I had plan to move reports from one server (reporting service) to another
server (another reporting service).

Is there any ways to move reports instead of uploading all reports (rdl)
again into another server?

As far as I know, rdl is the xml file.
after uploading to reporting what is really happen on reporting service?
where does the rdl file go after uploading (publishing) ?

Thanks

RE: moving reports to another server Amarnath
11/8/2006 10:09:01 PM
Simple method is to use the deployment configuration screen (ie right click
on the project and properties) change the server name in the URL,it will get
deployed on to the other server. You can have scripts as well. basically when
you upload or deploy it builds and encrypts and stores in the database.
Amarnath


[quoted text, click to view]
Re: moving reports to another server MS newsgroup
11/9/2006 9:10:22 AM
so, then
I need at least upload or deploy rdl files to reporting service.??
Is it possible to export data (ie data in dbo.Catalog or something
else)from current sql server used for reporting service to the other sql
server which use another reporting service ???






[quoted text, click to view]

Re: moving reports to another server Bruce L-C [MVP]
11/9/2006 9:28:24 AM
Detailed instructions:

http://support.microsoft.com/default.aspx?scid=842425

If you don't have subscriptions and extensive security customization (for
instance certain reports or folders have different rights) then redeploying
is the easiest. Otherwise follow the instructions in the above link.


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

AddThis Social Bookmark Button