dbTalk Databases Forums  

Command line for Copy Paste ?

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


Discuss Command line for Copy Paste ? in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Harsh
 
Posts: n/a

Default Command line for Copy Paste ? - 09-11-2003 , 02:39 PM






I only want to copy and paste the database from one server to another
through a command line.

Is there anything besides archive restore?
If not, I only need to copy the cube structure. Is there a way to do
that?

Appreciate your answer.
Thanks and regards,
Harsh

Reply With Quote
  #2  
Old   
Sanka
 
Posts: n/a

Default Command line for Copy Paste ? - 09-11-2003 , 09:39 PM






Hi Harsh,

Register both the servers in the Analysis Manager.
Right Click on the Database You want to Copy,
Select "Copy" and paste it on the destination Server.

This will copy only the Cube Structure. You might need to
reprocess the Cubes again to get the Data loaded in the
Cube.

HTH.
Cheers,
Sanka

Quote:
-----Original Message-----
I only want to copy and paste the database from one
server to another
through a command line.

Is there anything besides archive restore?
If not, I only need to copy the cube structure. Is there
a way to do
that?

Appreciate your answer.
Thanks and regards,
Harsh
.


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.