I have several hundred reports that I need to change the Datasource to point
to another server. Without going one report property at a time and changing
the datasource, is there a way to run an update statement on ReportServer
database to use the new target server for the said reports? If running an
update is not advisable then how do I make global change to the reports data
sources?
Thanks in advance for the assistance.
--
Lito DWhy don't you just change the connection string of the current Data Source
instead of creating a new one and changing all of the reports?
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Datasource
> thread-index: AcgQYLyNYww3Wxw0QxS8ZfpBNLID8A==> X-WBNR-Posting-Host: 207.46.19.168
> From: =?Utf-8?B?TElUTw==?= <anynomous@.msn.com>
> Subject: Datasource
> Date: Tue, 16 Oct 2007 18:55:04 -0700
> I have several hundred reports that I need to change the Datasource to
point
> to another server. Without going one report property at a time and
changing
> the datasource, is there a way to run an update statement on ReportServer
> database to use the new target server for the said reports? If running an
> update is not advisable then how do I make global change to the reports
data
> sources?
> Thanks in advance for the assistance.
> --
> Lito D
>|||The problem is that some reports must stay on the live server whereas the
rest should go to another server having previous day old data. I assume
there is a utility ( not too familiar with rs.exec) that I can issue via
command line to change the datasource from one to another then manually
change the few reports that must stay on the live server.
Lito D
"Chris Alton [MSFT]" wrote:
> Why don't you just change the connection string of the current Data Source
> instead of creating a new one and changing all of the reports?
> --
> Chris Alton, Microsoft Corp.
> SQL Server Developer Support Engineer
> This posting is provided "AS IS" with no warranties, and confers no rights.
> --
> > Thread-Topic: Datasource
> > thread-index: AcgQYLyNYww3Wxw0QxS8ZfpBNLID8A==> > X-WBNR-Posting-Host: 207.46.19.168
> > From: =?Utf-8?B?TElUTw==?= <anynomous@.msn.com>
> > Subject: Datasource
> > Date: Tue, 16 Oct 2007 18:55:04 -0700
> >
> > I have several hundred reports that I need to change the Datasource to
> point
> > to another server. Without going one report property at a time and
> changing
> > the datasource, is there a way to run an update statement on ReportServer
> > database to use the new target server for the said reports? If running an
> > update is not advisable then how do I make global change to the reports
> data
> > sources?
> >
> > Thanks in advance for the assistance.
> >
> > --
> > Lito D
> >
>|||If you are using a Shared DataSource for your reports then you are going to
have to create a new Data Source anyway. So if all you have are a few
reports to change that stay on the live server then just change the
existing Shared Data Source to point to the new server and then create a
second Data Source that points to the old server. Then manually change the
few reports to the new Shared Data Source. If you are using embedded Data
Sources in your reports then you've got a tedious job ahead of you. The
following tool might help you out but its a 3rd party tool and I haven't
really used it extensively.
http://www.sqldbatips.com/showarticle.asp?ID=62
--
Chris Alton, Microsoft Corp.
SQL Server Developer Support Engineer
This posting is provided "AS IS" with no warranties, and confers no rights.
--
> Thread-Topic: Datasource
> thread-index: AcgRFlfiLyP20tutQlCHtUWElaYfEw==> X-WBNR-Posting-Host: 207.46.19.197
> From: =?Utf-8?B?TElUTw==?= <anynomous@.msn.com>
> References: <A60B2818-F70D-4150-BBA9-41BEC7FCDC93@.microsoft.com>
<4c7dqiMEIHA.360@.TK2MSFTNGHUB02.phx.gbl>
> Subject: RE: Datasource
> Date: Wed, 17 Oct 2007 16:35:04 -0700
> The problem is that some reports must stay on the live server whereas the
> rest should go to another server having previous day old data. I assume
> there is a utility ( not too familiar with rs.exec) that I can issue via
> command line to change the datasource from one to another then manually
> change the few reports that must stay on the live server.
>
> --
> Lito D
>
> "Chris Alton [MSFT]" wrote:
> > Why don't you just change the connection string of the current Data
Source
> > instead of creating a new one and changing all of the reports?
> >
> > --
> > Chris Alton, Microsoft Corp.
> > SQL Server Developer Support Engineer
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> > --
> > > Thread-Topic: Datasource
> > > thread-index: AcgQYLyNYww3Wxw0QxS8ZfpBNLID8A==> > > X-WBNR-Posting-Host: 207.46.19.168
> > > From: =?Utf-8?B?TElUTw==?= <anynomous@.msn.com>
> > > Subject: Datasource
> > > Date: Tue, 16 Oct 2007 18:55:04 -0700
> > >
> > > I have several hundred reports that I need to change the Datasource
to
> > point
> > > to another server. Without going one report property at a time and
> > changing
> > > the datasource, is there a way to run an update statement on
ReportServer
> > > database to use the new target server for the said reports? If
running an
> > > update is not advisable then how do I make global change to the
reports
> > data
> > > sources?
> > >
> > > Thanks in advance for the assistance.
> > >
> > > --
> > > Lito D
> > >
> >
> >
>sql
