Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
SQLboom
Yak Posting Veteran
63 Posts |
 Posted - 2003-12-08 : 23:46:22
|
| Hi,can anyone please elaborate how to send a cube from a server to a remote server by any means possible.. . . .Also, Can anyone suggest the least possible unit that can be transferred from a cube to another remote server by any means (say as a file or otherwise).. . .So far the RnD suggests that the cube is the smallest unit that can be exported through MDX files. Now, say, i change a dimension of a cube then there seems no point in sending the cube as a whole.. . if i can send only the dimension changed. . .. ?????Help Please!Thanks |
|
|
TimChenAllen
Starting Member
45 Posts |
Posted - 2003-12-09 : 03:36:53
|
quote:
Originally posted by SQLboom
Hi,can anyone please elaborate how to send a cube from a server to a remote server by any means possible.. . . .Also, Can anyone suggest the least possible unit that can be transferred from a cube to another remote server by any means (say as a file or otherwise).. . .So far the RnD suggests that the cube is the smallest unit that can be exported through MDX files. Now, say, i change a dimension of a cube then there seems no point in sending the cube as a whole.. . if i can send only the dimension changed. . .. ?????Help Please!Thanks
The way I've transfered cubes has always been to Archive the database. As far as I know, this is the only way. One thing which you can do to make this less painful is to make a copy of the cube without data-- that is, only the structure. You do this by:1) Copy the database to a temporary database: from Analysis Manager, right click the database and select "Copy", then right click the server and select "Paste". Change the name of the new database.2) Right click the new database and select "Archive Database".Now instead of moving megabytes of data, you are moving kilobytes of cube structure. The tiny CAB file (my last one was 44KB) you produce by doing this can then be copied to another server.Hope this helps.--Timothy Chen Allenemail me if you have a job in New Orleans for me[url]http://www.timallen.org[/url] |
 |
|
|
SQLboom
Yak Posting Veteran
63 Posts |
Posted - 2003-12-09 : 22:55:17
|
| It did break the ice. Thanks a lot for ur help. Again, i still imagine if cube/dimension only could be exported. |
|
|
|
|
|
|
|
|
Exporting a cube