Copying reports to server

What is the best/fastest way of copying lots of user developed reports from
one server to the other.
TIA..Copy the RDL if you have access to it.
"sqlster" <trisha@.nospam.nospam> wrote in message
news:2DE69E99-C99B-4844-8B46-805E0F265E4E@.microsoft.com...
> What is the best/fastest way of copying lots of user developed reports
> from
> one server to the other.
> TIA..|||No, this does not work. At the server the RDL does not exist as a file, it
is stored in the database. You have to either manually extract the RDL using
Report Manager or using scripting. For a lot of reports, scripting is best.
Search Books Online on the word scripting. Also, a variety of people have
posted about scripting this as well. It ships with a scripting example for
publishing reports, need to have a script to extract the reports and then
you are good to go.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Patrick Allmond" <patrick24601@.yahoo.com> wrote in message
news:Y_pIe.65331$5N3.3008@.bgtnsc05-news.ops.worldnet.att.net...
> Copy the RDL if you have access to it.
> "sqlster" <trisha@.nospam.nospam> wrote in message
> news:2DE69E99-C99B-4844-8B46-805E0F265E4E@.microsoft.com...
>> What is the best/fastest way of copying lots of user developed reports
>> from
>> one server to the other.
>> TIA..
>|||Can anyone point me in the direction of a sample script ?
I know reports can be published using the rsutility, but i dont know of any
equivalent to extract or copy the rdl files once they have been uploaded.
Regards
Kamlesh
"Bruce L-C [MVP]" wrote:
> No, this does not work. At the server the RDL does not exist as a file, it
> is stored in the database. You have to either manually extract the RDL using
> Report Manager or using scripting. For a lot of reports, scripting is best.
> Search Books Online on the word scripting. Also, a variety of people have
> posted about scripting this as well. It ships with a scripting example for
> publishing reports, need to have a script to extract the reports and then
> you are good to go.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Patrick Allmond" <patrick24601@.yahoo.com> wrote in message
> news:Y_pIe.65331$5N3.3008@.bgtnsc05-news.ops.worldnet.att.net...
> > Copy the RDL if you have access to it.
> >
> > "sqlster" <trisha@.nospam.nospam> wrote in message
> > news:2DE69E99-C99B-4844-8B46-805E0F265E4E@.microsoft.com...
> >> What is the best/fastest way of copying lots of user developed reports
> >> from
> >> one server to the other.
> >>
> >> TIA..
> >
> >
>
>