Unfortunately, I inherited this and they are not in Visual Studio, that
I can find. Also, I am only moving one report.
Todd Melcher
Database Administrator
Pitney Bowes PSI Presort Services
Work Phone: 402-935-3858
Cell Phone: 402-709-9216
-----Original Message-----
From: Jaime E. Maccou
[mailto:mssqldba-ezmlmshield-x17410570.[Email address protected]
Sent: Wednesday, April 30, 2008 2:30 PM
To: LazyDBA Discussion
Subject: Re: Reporting Services
Are you moving one report or you want to report all your reports?
If you design and save your reports in Visual Studio, change your Server
Reports Property Pages "TargetServerURL" and deploy it
Note: If your datasources already exists set your OverwriteDatasources
to "false", if not set to "true"
You can follow the same for a single report
If you need another options let me know.
----- Original Message -----
From: "erancher1852" <mssqldba-ezmlmshield-x49284191.[Email address
protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, April 30, 2008 2:35:42 PM (GMT-0500) America/New_York
Subject: Re: Reporting Services
Backup and restore your report server databases to your target server.
Modify your SSRS configuration to point at new server locations. Be
mindful
that Reporting Services works best in default instance. Also beware the
you
may have to cycle IIS a few times to refresh all of your reports.
On Wed, 30 Apr 2008 13:30:08 -0500, Todd Melcher wrote
> I am trying to move a report from one Server to another. Are there
> suggestions on the best way to go about this?
>
> Todd Melcher
>
> Database Administrator
>
> Pitney Bowes PSI Presort Services
>
> Work Phone: 402-935-3858
>
> Cell Phone: 402-709-9216
>
> This email message may contain confidential, proprietary and/or
> privileged information. It is intended for use of the intended
> recipient(s). If you have received it in error, please immediately
> advise the sender by reply email and then delete the message. Any
> disclosure, copying, distribution or use of the information
> contained in this email message to or by anyone other than the
> intended recipient is strictly prohibited. Any views expressed in
> this message are those of the individual sender, except where the
> sender specifically states them to be the view of the Company. Thank
> you.
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
--
WOW! Homepage (http://www.wowway.com)
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
This email message may contain confidential, proprietary and/or privileged information. It is intended for use of the intended recipient(s). If you have received it in error, please immediately advise the sender by reply email and then delete the message. Any disclosure, copying, distribution or use of the information contained in this email message to or by anyone other than the intended recipient is strictly prohibited. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the view of the Company. Thank you.
MS Sql Server LazyDBA home page