|
Home > Archive > MS SQL Data Warehousing > October 2006 > Export Cube Structure
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Export Cube Structure
|
|
| Ibon Colias 2006-10-25, 6:01 am |
| Hi all !!
I would like to export a cube from a server to another. I don't need to
export any data, just the structure, fact table and some DTS packages. Any
idea ??
I work with SQL Server 2000 Standard Edition.
Thanks in advance. IBON
| |
| Dejan Sarka 2006-10-25, 6:01 am |
| > I would like to export a cube from a server to another. I don't need to
> export any data, just the structure, fact table and some DTS packages. Any
> idea ??
>
> I work with SQL Server 2000 Standard Edition.
>
In Analysys Manager 2000, right-click on the database you want to move to
another server and select Copy. Copy the db on the same server (source) into
a new db. Copy option copies meta data only. Now you can backup the new db
on the source server, copy the backup and restore it on the destination
server.
DTS packages can be saved to files with Enterprise Manager. Then you can
copy them and open them on the destination server and save them to msdb of
the destination server.
--
Dejan Sarka, SQL Server MVP
Mentor, www. SolidQualityLearning
.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message
| |
| Ibon Colias 2006-10-25, 6:01 am |
| Thanks Dejan !!
It works well !!
"Dejan Sarka" < dejan_please_reply_t
o_newsgroups.sarka@avtenta.si> escribió
en el mensaje news:O7N91Rb8GHA.568@TK2MSFTNGP05.phx.gbl...
>
> In Analysys Manager 2000, right-click on the database you want to move to
> another server and select Copy. Copy the db on the same server (source)
> into a new db. Copy option copies meta data only. Now you can backup the
> new db on the source server, copy the backup and restore it on the
> destination server.
> DTS packages can be saved to files with Enterprise Manager. Then you can
> copy them and open them on the destination server and save them to msdb of
> the destination server.
>
> --
> Dejan Sarka, SQL Server MVP
> Mentor, www. SolidQualityLearning
.com
> Anything written in this message represents solely the point of view of
> the sender.
> This message does not imply endorsement from Solid Quality Learning, and
> it does not represent the point of view of Solid Quality Learning or any
> other person, company or institution mentioned in this message
>
>
>
|
|
|
|
|