dbTalk Databases Forums  

Transfering cubes from one server to other

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Transfering cubes from one server to other in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Amit Pal Singh
 
Posts: n/a

Default Transfering cubes from one server to other - 12-08-2003 , 01:26 AM






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


Reply With Quote
  #2  
Old   
Bas Kersten [MSFT]
 
Posts: n/a

Default RE: Transfering cubes from one server to other - 12-08-2003 , 02:19 AM






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."


Reply With Quote
  #3  
Old   
Amit Pal Singh
 
Posts: n/a

Default RE: Transfering cubes from one server to other - 12-08-2003 , 03:06 AM



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

Reply With Quote
  #4  
Old   
sp
 
Posts: n/a

Default RE: Transfering cubes from one server to other - 12-12-2003 , 10:42 AM



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

Thanks


Quote:
-----Original Message-----
Hi ,

I have added a copy to this posting.

HTH,
Bas

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

Reply With Quote
  #5  
Old   
Harsh
 
Posts: n/a

Default Re: Transfering cubes from one server to other - 12-12-2003 , 10:16 PM



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"

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.