Hi.
I need to move olap database with repository in native format on sql server
in from server1 to server2, How do I to do this ?

Thanks in advance

Simon

Simon,
the easiest way is probably to install Analysis Services
on the new server, archive every db on the old server and
restore them on the new server.

To make this even simpler, you can make a copy of an
Analysis Server database (copy&paste), thereby just
leaving the metadata. You can archive and restore that
since you have to reprocess anyway.

If you need to transfer your data as well, copy the data
folder as stated in the "Copy from C to D answer" from
Sanka. Just copy it on the new server, then copy
repository as well, then reset Analysis Server connection.

HTH Lutz

Thank Lutz.

Now I try.


"Lutz Morrien" <Lutz.Morrien (AT) ocb (DOT) com.withoutthisbit> wrote