|
Home > Archive > MS SQL Server OLAP > March 2006 > datasource after restore
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
datasource after restore
|
|
| Klaus Wiesel 2006-03-24, 9:31 am |
| Hello
Under SQL Server 2000 SP4 / Analysis Services I try to move an
analysis database from server A to server B.
On server A, I want to process data which comes from a SQL Server
database C, on server B the name of the (identically structured)
database is D.
How can I do this?
After restoring from a CAB file the data source may be changed but it
must be buried somewhere else in the database
Do I have to use a special provider to avoid this?
Regards
Klaus Wiesel
| |
| Dave Wickert [MSFT] 2006-03-24, 11:39 am |
| If you need it interactively, just edit the data source using Analysis
Manager.
If you need it programmatically, write a VB script which uses DSO to edit
the data source.
A sample VB script that use DSO, look at the AS Operations Guide, here
http://www.microsoft.com/technet/pr...n/anservog.mspx
(Appendix H, I and J)
It doesn't have one that edits the data source, but it does other DSO
operations so you can use it to jumpstart your work.
--
Dave Wickert [MSFT]
dwickert@online.microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Klaus Wiesel" <klaus.wiesel@infor.com> wrote in message
news:O90VJ90TGHA.2156@tk2msftngp13.phx.gbl...
> Hello
>
> Under SQL Server 2000 SP4 / Analysis Services I try to move an
> analysis database from server A to server B.
> On server A, I want to process data which comes from a SQL Server database
> C, on server B the name of the (identically structured) database is D.
>
> How can I do this?
>
> After restoring from a CAB file the data source may be changed but it must
> be buried somewhere else in the database
>
> Do I have to use a special provider to avoid this?
>
> Regards
> Klaus Wiesel
| |
| Klaus Wiesel 2006-03-26, 7:39 am |
| Hi
as described, I have a problem just editing the datasource - it is
somewhere inside because I cannot process a cube after editing it - the
old datasource is still in there...
Regards
Klaus
Dave Wickert [MSFT] wrote:
> If you need it interactively, just edit the data source using Analysis
> Manager.
>
> If you need it programmatically, write a VB script which uses DSO to edit
> the data source.
> A sample VB script that use DSO, look at the AS Operations Guide, here
> http://www.microsoft.com/technet/pr...n/anservog.mspx
> (Appendix H, I and J)
> It doesn't have one that edits the data source, but it does other DSO
> operations so you can use it to jumpstart your work.
>
|
|
|
|
|