OLAP Cube Migration

[Rob999]

Hello everyone!

I have about 15 OLAP cubes on one server and we now have a new server. I'm able to transfer my DTS packages to the new server by doing a File>SaveAs inside the edit window, but the OLAP cubes do not appear to have that option.

Is there a way to copy/transfer/saveAs, etc. Cube files from one location to another, or do I have to rebuild them all on the new Server?

Any comments are much appreciated. Thanks.

 

[dky1e]

I've run into this

http://www.microsoft.com/sql/downloads/OLAPaddin.asp

"Archiving and restoring databases. Archives and restores OLAP Services databases from within the OLAP Manager. This utility also enables databases to be archived from one server and restored to another."

Let me know if it helps.