Copy cubes from Dev to test server

[SP1709]

I need to copy some cubes (4 nos.) and calculated members (50 nos.) from dev server to test server. Can you please tell me how do you do that? Any help would be appreciated.

Following is scenario

Database contains around 15 cubes and a virtual cube. 4 Of these are new cubes so need to be moved to test server from development without touching other cubes. Also virtual cube contains new calculated measures which need to be moved without touching other structure of virtual cube. Can this be Acheived.

Thanks,
SP

 

[mrdenny]

Not really. There are only two ways that I've found to move objects. Backup the Analysis Services Database, and restore it from the dev box then do a full population.

Or manually create the new objects.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[MDXer]

what version of Analysis services are you using?


Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[mrdenny]

2000.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[SP1709]

Thanks for the response. Also is there anyway to atleast change the datasource connection name for the cubes.

 

[mrdenny]

The connections them selves can be edited, but they can't be renamed (unless you hack the meta data database than SSAS uses, which I wouldn't recommend).

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com