Supported Migration Paths for Analysis Services Repositories

Analysis Services

Analysis Services

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.

See Also

Migrating Analysis Services Repositories

OLE DB Provider for Jet