Migrating Analysis Services Repositories
For each Analysis server, Microsoft® SQL Server™ 2000 Analysis Services creates a repository called the Analysis Services repository to store meta data for the objects of the Analysis server (cubes, dimensions, and so on). By default, this repository is a Microsoft Access (.mdb) database on the server computer where Analysis Services is installed. By default, this database is:
C:\Program Files\Microsoft Analysis 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.
You can change the format of your repository when you migrate it from the default Microsoft Access database to a SQL Server database or from one SQL Server database to another SQL Server database. By default the repository is in SQL Server 7.0 OLAP Services format. You can keep this format when you migrate the repository or you can change the format to use the SQL Server 2000 Meta Data Services repository format. If you choose to use the Meta Data Services format, it is recommended that you store the repository in the msdb database, which is where other SQL Server components store their repositories in this format. You can also change the repository from Meta Data Services format to SQL Server 7.0 OLAP Services format when you migrate it from one SQL Server database to another.
Before you start the Migrate Repository Wizard, create or identify the SQL Server database to which you want to migrate the Analysis Services repository.
To start the Migrate Repository Wizard