SQL Server Performance

Migration of SSAS from SQL 2000 to 2008

Discussion in 'Getting Started' started by kranpura, Feb 4, 2010.

  1. kranpura New Member

    Upgrade Advisor show 'Invalid objects cause migration to fail'. It is showing 17 objects from Different cubes. In the environment there are 5 cubes and around 500 GB of data. I am planning for Side-by-side migration of DE and SSAS.So what can be the Invalid objects present in the SQL 2000 SSAS.Any Help Appreciated.Thanks.
  2. dineshasanka Moderator

  3. satya Moderator

    Welcome to the forums.
    MS documentation refers that:When you upgrade from SQL Server 2000 Analysis Services to SQL Server 2008 Analysis Services, because of changes to the underlying architecture, it is best to perform the upgrade in two steps. First, install SQL Server 2008 Analysis Services side-by-side with SQL Server 2000 Analysis Services. Then, use the Analysis Services Migration Wizard to migrate SQL Server 2000 Analysis Services databases to the SQL Server 2008 Analysis Services format. The Analysis Services Migration Wizard migrates SQL Server 2000 Analysis Services database metadata to SQL Server 2008 Analysis Services and re-creates the database structures in the SQL Server 2008 Analysis Services database format while leaving the original databases intact. For more information, see How to: Install Analysis Services Side-by-Side with an Earlier Version and Migrating Existing Analysis Services Databases.
    If you remove the default instance of SQL Server 2000 Analysis Services after you have migrated its databases, you can use the Analysis Services Instance Rename tool to make a named instance of SQL Server 2008 Analysis Services the default instance on the server. For more information, see How to: Rename an Instance of Analysis Services.
    To upgrade SQL Server 2000 Analysis Services
    1. Install a named instance of SQL Server 2008 Analysis Services by using the SQL Server Installation Wizard or an alternative installation method. For more information, see Considerations for Installing Analysis Services or How to: Install SQL Server 2008 from the Command Prompt.
    2. Use the Analysis Services Migration Wizard to migrate SQL Server 2000 Analysis Services database metadata to SQL Server 2008 Analysis Services. This step re-creates the database structures in the SQL Server 2008 Analysis Services database format while leaving the original databases intact. For more information, see Migrating Existing Analysis Services Databases.
    3. Process the new SQL Server 2008 Analysis Services databases. This step populates the new database structures with data. For more information, see Processing Analysis Services Objects.
    4. Verify the database upgrade process. Review the upgraded databases in SQL Server Management Studio, and test them with your client applications.
    5. Uninstall the earlier version of Analysis Services if it is no longer needed.
    FYI

Share This Page