O'Reilly logo

Professional SQL Server™ Analysis Services 2005 with MDX by Stephen R. Quinn, Sivakumar Harinath

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

2.2. Upgrading to Analysis Services 2005

If you currently do not have a requirement of upgrading your Analysis Services 2000 to Analysis Services 2005 or you are a first time user of Analysis Services then you can jump to the next section. The upgrade process in general is not a seamless process, and not without its share of gotchas. This is especially true when much of the product has been redesigned, such as you are faced with going from Analysis Services 2000 to Analysis Services 2005. Fortunately, Analysis Services 2005 provides you with a tool called Upgrade Advisor to prepare you to upgrade databases from Analysis Services 2000. Upgrade Advisor is available as a redistributable package with SQL Server 2005. You need to install Upgrade Advisor from the Servers\redist\Upgrade Advisor folder on your CD/DVD. When you run Upgrade Advisor on your existing Analysis Services 2000 instance, Upgrade Advisor informs you whether your database(s) will be upgraded successfully without any known issues. Warnings are provided by Upgrade Advisor in cases where there might be changes in the names of the dimensions or cubes due to the Analysis Services 2005 architecture. Once you have reviewed all the information from Upgrade Advisor, you are ready to start the upgrade. Follow the steps below to use Upgrade Advisor for analyzing the effects of upgrading your Analysis Services 2000 to Analysis Services 2005.

  1. Go to "Program Files\Microsoft SQL Server 2005 Upgrade Advisor" folder on your machine ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required