Does anyone have a script that they would like to share that would move some directory and it's tree from one server to another?
Thanks!
ScottI don't have one but note that reports are not in any directories. They are
stored in the database. They only exist in files on the development
machines. When you deploy they are stored in the database.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in message
news:ecuGSBr8EHA.4072@.TK2MSFTNGP10.phx.gbl...
> Does anyone have a script that they would like to share that would move
some directory and it's tree from one server to another?
> Thanks!
> Scott
>|||Right, but the whole API is also scriptable, correct?
I'm just wondering if there is a script that I can use with the RS script engine that will move reports (i.e. from dev to prod)
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message news:uHEwIEr8EHA.1452@.TK2MSFTNGP11.phx.gbl...
>I don't have one but note that reports are not in any directories. They are
> stored in the database. They only exist in files on the development
> machines. When you deploy they are stored in the database.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in message
> news:ecuGSBr8EHA.4072@.TK2MSFTNGP10.phx.gbl...
>> Does anyone have a script that they would like to share that would move
> some directory and it's tree from one server to another?
>> Thanks!
>> Scott
>>
>|||Yes you can script it and RS ships with an example. I'm at home so I can't
tell you where it is. Note that you can setup multiple targes for deploying
from Visual Studio. Also, you can deploy a single report, multiple reports
or all reports. The first time you deploy the data sources get deployed and
then you need to go to Report Manager and reconfigure them to go against
your production data but thereafter the default is to not overwrite the data
sources so you just get a warning that it couldn't deploy the data sources.
You might want to play around some with the capabilities in the designer for
deployment before deciding you need to script it.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in message
news:OSVmFqt8EHA.3336@.TK2MSFTNGP11.phx.gbl...
> Right, but the whole API is also scriptable, correct?
> I'm just wondering if there is a script that I can use with the RS script
> engine that will move reports (i.e. from dev to prod)
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:uHEwIEr8EHA.1452@.TK2MSFTNGP11.phx.gbl...
>>I don't have one but note that reports are not in any directories. They
>>are
>> stored in the database. They only exist in files on the development
>> machines. When you deploy they are stored in the database.
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Scott Meddows" <scott_meddows_no_spm@.tsged-removeme.com> wrote in
>> message
>> news:ecuGSBr8EHA.4072@.TK2MSFTNGP10.phx.gbl...
>> Does anyone have a script that they would like to share that would move
>> some directory and it's tree from one server to another?
>> Thanks!
>> Scott
>>
>>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment