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
> 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
|||Thanks Dejan !!
It works well !!
"Dejan Sarka" <dejan_please_reply_to_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
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment