Professional Microsoft® SQL Server® Analysis Services 2008 with MDX

2.2. Upgrading to Analysis Services 2008

You can upgrade to Analysis Services 2008 from Analysis Services 2000 or Analysis Services 2005. If you currently do not have a requirement of upgrading your previous Analysis Services instances to Analysis Services 2008 or if you are a first time user of Analysis Services you can jump to the next section. The Analysis Services 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 2008. Fortunately, Analysis Services 2008 provides a tool called Upgrade Advisor to prepare you to upgrade databases from Analysis Services 2000 and Analysis Services 2005 to Analysis Services 2008. Upgrade Advisor is available as a redistributable package with SQL Server 2008. You need to install Upgrade Advisor from the <processor architecture>\redist\Upgrade Advisor folder on your CD/DVD. Install the Upgrade Advisor on your machine. When you run Upgrade Advisor on your existing Analysis Services 2000 or 2005 instance, Upgrade Advisor informs you whether or not your database(s) will be upgraded successfully without any known issues. Errors and warnings are provided by Upgrade Advisor in cases where upgrade of some of the objects/definitions is not feasible or when there are potential changes in the names of dimensions or cubes during the upgrade process due to the Analysis ...