We have to create cubes on our local server and then we have to transfer these cubes to other server.

How we can transfer individual cubes from one server to another, or how we can transfer the changes made to a inividual cube to another server.

We want to transfer the individual cubes from one server to other only.

Can somebody help us.
Thanks in advance

Regards
Amit P Singh

Hi Amit,

Easiest way is to register both server with your AS manager, and select you
cube on the source server, r.click, copy, go to the destintation cube and
dat a paste in there. Process the cube when you are ready.

Other options are:
*archive and restore trough the AS manager
*use of the SQL resource kit tool metadatascripter

HTH,
Bas

"This posting is provided "AS IS" with no warranties, and confers no
rights."

Thanks Bas for yr help.

we are not having the Meta Data Scripter in our SQL SERVER 2000's CD.
Is it downloadble. If yes then could you plz tell me from where I can download it.

Regards
Amit P Singh

Can I please request a copy , I don't seem to have a copy
eIther, or the URL where I can download it...

Thanks

Rem Bat File
============

cd C:\Program Files\Microsoft Analysis Services\Bin

Rem Source Server
msmdarch /a "SERVERNAME" "\\SERVERNAME\DataFolder" "FoodMart 2000"
"C:\FoodMart.cab"

Rem Destination Server
msmdarch /r "SERVERNAME" "\\SERVERNAME\DataFolder\" "C:\FoodMart.cab"
"C:\Log.log"