Upgrading Analysis Services
The following sections highlight some important considerations you should be aware of when upgrading Analysis Services.
Upgrading from SQL Server 2005 Analysis Services
You can upgrade an existing instance of SQL Server 2005 Analysis Services to SQL Server 2008 Analysis Services using the Upgrade Wizard. The wizard automatically migrates existing databases from the old instance to the new instance. The metadata and binary data is compatible between the SQL Server 2005 and SQL Server 2008, so the data is retained after you upgrade. You do not have to manually migrate the data. To upgrade an existing instance of SQL Server 2005 Analysis Services, run the Upgrade Wizard and specify the name of the existing AS instance ...
Get Microsoft® SQL Server 2008 R2 Unleashed 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.
