Databases Reference
In-Depth Information
nect to Analysis Services 8.0 (Analysis Services 2000), followed by Analysis
Services 7.0. When connections to both Analysis Services 8.0 and 7.0 fail
DSO 8.5 connects to Analysis Services 2005 through AMO. Repository con-
nection string information and the locks directory are garnered and stored as
properties in the Analysis Services configuration file when Analysis Services
2000 is upgraded to Analysis Services 2005. AMO returns the repository con-
nection string and lock directory properties to DSO 8.5. Changes to the Ana-
lysis Services database initiated by the DSO application such as modifica-
tions to dimensions, cubes or mining models, are only reflected in the reposit-
ory. When the client application issues a process command; then DSO8.5 re-
trieves the metadata for the database, uses the migration DLL to migrate to
Analysis Services 2005 objects and then, using AMO, sends the entire data-
base to be updated to Analysis Services 2005. Any information that is up-
dated on the database in the meantime using SQL Server 2005 tools would
be lost. After the migration or upgrade from Analysis Services 2000 to Analys-
is Services 2005 if you make any changes to the imported database, which
uses features specific to Analysis Services 2005 we recommend you not con-
tinue on with your legacy DSO application. We encourage you to re-write your
management application using AMO unless it is cost prohibitive to do so.
Search WWH ::
Custom Search