Re: Issue with Migrating OLAP Cube
From: Steven Wong (anonymous_at_discussions.microsoft.com)
Date: 09/03/04
- Next message: MDX: "MDX Question"
- Previous message: Chet Cromer: "Re: Error 80004005 - Database ... does not exist"
- In reply to: Dave Wickert [MSFT]: "Re: Issue with Migrating OLAP Cube"
- Next in thread: Dave Wickert [MSFT]: "Re: Issue with Migrating OLAP Cube"
- Reply: Dave Wickert [MSFT]: "Re: Issue with Migrating OLAP Cube"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 3 Sep 2004 09:28:51 -0700
I tried your scenario and it works fine. My real scenario
differs from your scenario in that: 1) The AS database
NAME and data source NAME are the same in dev server and
uat server, but the underlying SQL database differs. 2)
Copy/pasting in 2 diff servers.
I tried your #2 using my AS dbname1 on my dev machine. I
copy/pasted a new AS dbname2 (obviously, need a new name)
into the same dev server, then, deleted a couple of cubes
from the AS dbname2. Then, I copy those same cubes from
the AS dbname1 and pasted them into AS dbname2, and they
work fine.
Any further thoughts why it still won't work in my real
scenario?
>-----Original Message-----
>Hmmm..
>
>So I did the following to try and reproduce the problem.
>I cut and pasted Foodmart 2000 to Foodmart 2000 Test.
>In Foodmart 2000 Test, I deleted the HR cube and all of
the mining
>models/dimensions.
>I processed the database. Everything processed clean.
>Now the only difference between Foodmart 2000 and
Foodmart 2000 Test is that
>the HR cube is missing in Foodmart 2000 Test.
>
>I then cut & pasted the HR cube from Foodmart 2000 to
Foodmart 2000 Test.
>Everything went OK and then I could process the HR cube
without any
>problems.
>
>How is that different from your scenerio? Anything
different?
>The only thing that I can think of is that it is on the
same machine.
>
>1) can you try the above and see if the same thing
happens on your machine
>2) can you try your scenerio but have both databases be
on the same machine
>
>--
>Dave Wickert [MSFT]
>dwickert@online.microsoft.com
>Program Manager
>BI SystemsTeam
>SQL BI Product Unit (Analysis Services)
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>
>"Steven Wong" <anonymous@discussions.microsoft.com> wrote
in message
>news:547c01c49145$67030a80$a301280a@phx.gbl...
>>
>>
>> When I say "move", I was trying to copy/paste the new
>> cubes from dev Analysis Services (AS) server to UAT AS
>> server. Both data source names are the same in both AS
>> server except they are pointed to its own respective
>> underlying SQL database.
>>
>> Did that help?
>>
>>
>> >-----Original Message-----
>> >Can you be more specific? When you say "move" your cube
>> from dev to
>> >production, what do you mean? What technique are you
>> using?
>> >--
>> >Dave Wickert [MSFT]
>> >dwickert@online.microsoft.com
>> >Program Manager
>> >BI SystemsTeam
>> >SQL BI Product Unit (Analysis Services)
>> >--
>> >This posting is provided "AS IS" with no warranties,
and
>> confers no rights.
>> >
>> >"Steven Wong" <anonymous@discussions.microsoft.com>
wrote
>> in message
>> >news:4f8201c49111$6605bc60$a501280a@phx.gbl...
>> >> Hi Dave:
>> >>
>> >> The articles do not address migration of new OLAP
cubes
>> >> between existing AS databases.
>> >>
>> >> I need to move the new OLAP cubes from my dev AS
>> database
>> >> over to my UAT AS database, but is getting this
>> >> message "The target database has a data source name
that
>> >> has the same name as the datasource for the source
>> >> cube..." when I copy the new OLAP cube over.
>> >>
>> >> It seems like the following are my only options:
>> >> 1) Delete the AS database on UAT server, and recover
an
>> >> archive copy of the AS database from dev server with
all
>> >> the new OLAP cubes on the UAT server.
>> >> 2) Manually re-create all the new OLAP cubes on my
UAT
>> >> server. (Would hate to it over when migrate to
>> production!)
>> >>
>> >> Does Microsoft has any other options? Any advice
will
>> be
>> >> very much appreciated.
>> >>
>> >> Thanks in advance.
>> >>
>> >>
>> >> >-----Original Message-----
>> >> >See the section titled "Release Management" in the
>> >> Analysis Services
>> >> >Operations Guide.
>> >>
>>
>http://www.microsoft.com/technet/prodtechnol/sql/2000/main
>> >> tain/anservog.mspx
>> >> >It might have some material to assist this activity.
>> >> Notably the discussion
>> >> >of (and pointer to) the DSO/XML utility.
>> >> >--
>> >> >Dave Wickert [MSFT]
>> >> >dwickert@online.microsoft.com
>> >> >Program Manager
>> >> >BI SystemsTeam
>> >> >SQL BI Product Unit (Analysis Services)
>> >> >--
>> >> >This posting is provided "AS IS" with no warranties,
>> and
>> >> confers no rights.
>> >> >
>> >> >"Prasanna" <prasanna_b2001@yahoo.com> wrote in
message
>> >>
>news:bcfe7189.0408300744.34b30cb7@posting.google.com...
>> >> >> Hi All,
>> >> >> I have cubes in my local machine. Now I need to
>> >> replicate them in the
>> >> >> production server which is a remote machine.
Please
>> >> tell me how to
>> >> >> copy the
>> >> >> OLAP cube from my machine to the production
machine.
>> >> Please give me
>> >> >> the steps to do that.
>> >> >>
>> >> >> Thanks in Advance
>> >> >> Prasanna
>> >> >
>> >> >
>> >> >.
>> >> >
>> >
>> >
>> >.
>> >
>
>
>.
>
- Next message: MDX: "MDX Question"
- Previous message: Chet Cromer: "Re: Error 80004005 - Database ... does not exist"
- In reply to: Dave Wickert [MSFT]: "Re: Issue with Migrating OLAP Cube"
- Next in thread: Dave Wickert [MSFT]: "Re: Issue with Migrating OLAP Cube"
- Reply: Dave Wickert [MSFT]: "Re: Issue with Migrating OLAP Cube"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
