moving SSAS 2005 cube to another databases of same server or another server

Question

Post reply

moving SSAS 2005 cube to another databases of same server or another server

beejug1983

SSCertifiable

Points: 6491
More actions
May 21, 2012 at 11:33 pm

#274323

Hi,
I have a SSAS 2005 database where 2 cubes exist now I want to move one cube from source databse to another database on same server or another server. Remember I have to move only one cube not whole database.
Thaks in advance.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Henrico Bekker One Orange Chip Points: 27652 More actions · Answer 1

My personal advice would be to redeploy the cube to the new database...

Here's some guidelines:

http://social.msdn.microsoft.com/Forums/en-US/sqlanalysisservices/thread/eed8c65e-0cdc-401f-add4-693ab68f616e

http://www.sqlservercentral.com/articles/Analysis+Services+(SSAS)/69467/

-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle

beejug1983 SSCertifiable Points: 6491 More actions · Answer 2

Henrico,

I will try these all possbilities and let you know if something needed again.

Thanks a ton!