What is the easiest way to tranfer the structure of a OLAP-Database
from one server to an other server.

Analysis Services can make Cab-File as Backup and I can restore it on
an other server.

But I only want to transfer the structure, not the data.

Is this possible.

Many thanks.
aaapaul

AS Operations Guide
http://www.microsoft.com/technet/pro.../anservog.mspx
See the section on release management.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Systems Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


<lvpaul (AT) gmx (DOT) net> wrote

If you register both servers in the one copy of Analysis Manager you can
copy and paste the database. This will only transfer the structure.

--
Regards
Darren Gosbell [MCSD]
<dgosbell_at_yahoo_dot_com>
Blog: http://www.geekswithblogs.net/darrengosbell