Migrating OLAP Services Repositories

For each OLAP server, Microsoft® SQL Server™ OLAP Services creates a repository to store metadata for multidimensional objects such as cubes, dimensions, and so on. By default, this repository, called the “OLAP Services repository,” is a Microsoft Access (.mdb) database on the server computer where OLAP Services is installed. By default, this database is:

..\Program Files\OLAP Services\Bin\msmdrep.mdb

You can use the Migrate Repository wizard to migrate this repository to a SQL Server (.mdf) database on the same or another server computer. Later, you can use the wizard to migrate the repository to another SQL Server database.

Important After you migrate the repository to a SQL Server database, you cannot migrate the repository back to a Microsoft Access database.

Before you start the Migrate Repository wizard, create or identify the SQL Server database you want to migrate the OLAP Services repository to.

To start the Migrate Repository wizard

In the OLAP Manager tree view, expand the OLAP servers folder.
Right-click the server whose OLAP Services repository you want to migrate, and then click Migrate Repository.

After migration, both the old and new databases remain; however, only the new database is used by OLAP Services. You can manually delete the old database.

If an error prevents the Migrate Repository wizard from finishing successfully, the migration is canceled, and OLAP Services continues to use the repository it used before you started the wizard.