SQL Server Performance Forum – Threads Archive
How to move Cube to another serverHi, 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.
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.
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.