Supported Migration Paths for Analysis Services Repositories
You can migrate a Microsoft® SQL Server™ 2000 Analysis Services repository from the default Microsoft Access (Microsoft Jet 3.5 or 4.0) database to a SQL Server database on the same or a different computer. You cannot migrate a SQL Server repository to a Microsoft Access repository. You can change the format from native to SQL Server 2000 Meta Data Services format when you migrate a database. To migrate a SQL Server database repository between native and Meta Data Services formats, you must migrate it from one SQL Server database to another. The following table shows supported migration paths for repository databases.
| To native | To MDS | |||
|---|---|---|---|---|
| Jet 3.5/4.0 | SQL Server 7.0/2000 | SQL Server 2000 | ||
| From native | Jet 3.5/4.0 | No | Yes | Yes |
| SQL Server 7.0/2000 | No | Yes(2) | Yes(2) | |
| From MDS(1) | SQL Server 2000 | No | Yes(2) | Yes(2) |
1 MDS represents the Meta Data Services (previously named Microsoft Repository) format supported by SQL Server 2000.
2 Source and destination must be different databases.