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.
Go to "Program Files\Microsoft SQL Server 2005 Upgrade Advisor" folder on your machine ...
Get Professional SQL Server™ Analysis Services 2005 with MDX now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
