| Author |
Transfer OLAP-Database
|
|
| lvpaul@gmx.net 2005-09-27, 8:24 pm |
| 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
| |
| Dave Wickert [MSFT] 2005-09-27, 8:24 pm |
| AS Operations Guide
http://www.microsoft.com/technet/pr...n/anservog.mspx
See the section on release management.
--
Dave Wickert [MSFT]
dwickert@online.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@gmx.net> wrote in message
news:1127851388.602106.87340@z14g2000cwz.googlegroups.com...
> 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
>
| |
| Darren Gosbell 2005-09-28, 3:24 am |
| 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_do
t_com>
Blog: http://www.geekswithblogs.net/darrengosbell
|
|
|
|