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.
Thanks
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
http://www.SQL-Server-Performance.Com
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.
]]>