Hi all!

I'm really a newbie at Analysis services, as you will see, but I hope you
could help me with this one.

My idea was to move a Analysis Services SP4 installation from one server to
another.
When installing MSAS on new server I didn't migrate the repository to SQL
Server format before restoring the MSAS databases using *.CAB files created
on source server. So now I have a Access Db repository that's running and a
OLAP Repository database in SQL Server that I want to "connect" to.

Is it possible to migrate the repository "into" the existing SQL Server
database? Or do I need to migrate to a new/empty database? Do I really need
any information in the OLAP Repository SQL Server database that was moved
from the source server?

Hope that some of you understand my question and can point me in the right
direction.

Thanks
/Fredrik

you stop the service, swap out the repositories.. copy all the data
files to the data directory; start the service and you're in business..
right?

wait a second.. you have CABs for all your cubes?

then yeah.. migrate to SQL and right-click restore on each one



Fredrik wrote:

When the .cab archive file is created it takes a copy of all the data
and all the meta data that is stored in the repository for the database
that is being archived. When it is restored it restores the both data
and the repository information for that database.

So you should not need the old SQL repository, the restore operation
will have put the latest information into the Access DB. You should be
able to create a blank SQL database and re-migrate the repository.

Make sure you put the repository in its own database (It sounds like you
might be doing this anyway) I think the migration wizard default to
using msdb which is not a configuration I would recommend.

--
Regards
Darren Gosbell - SQL Server MVP
Blog: http://www.geekswithblogs.net/darrengosbell

In article <626C427C-ABEA-4185-9BCD-30C8D9603512 (AT) microsoft (DOT) com>,
Fredrik (AT) discussions (DOT) microsoft.com says...