How to move Cube to another server | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to move Cube to another server

Hi, How to move a cube from one server to another one server. I am using sql server 2000. I am new to analysis. Please help me.
S. Ramesh
There are several ways of doing this, the best way is to use Archive and Restore. First Archive the Database on Server A then Restore it on Server B. This will move the Data as well as the cubes and dimensions. You can also simply register Server B and Server A in the same Analysis Manager and then copy the database from Server A and paste it to Server B. This will move just the cube and dimension definitions.
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.