Friday, March 9, 2012

moving reports to another server

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) ?
ThanksSimple 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
"MS newsgroup" wrote:
> 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
>
>|||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 ?
"Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
news:9A0F43E3-90FB-4C2D-A8C9-72EF10F03E89@.microsoft.com...
> 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
>
> "MS newsgroup" wrote:
>> 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
>>|||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
"MS newsgroup" <klee@.jeromegroup.com> wrote in message
news:uMu9xEBBHHA.1224@.TK2MSFTNGP04.phx.gbl...
> 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 ?
>
>
>
> "Amarnath" <Amarnath@.discussions.microsoft.com> wrote in message
> news:9A0F43E3-90FB-4C2D-A8C9-72EF10F03E89@.microsoft.com...
>> 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
>>
>> "MS newsgroup" wrote:
>> 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
>>
>

No comments:

Post a Comment