Migrating SQL Server Analysis Services From 2000 to 2008

If you use Google to find how to migrate your cube definitions from AS 2000 to AS 2008, you'll probably find the following link from MSDN:

http://msdn.microsoft.com/en-us/library/ms143278%28v=sql.105%29.aspx

If you follow the instructions, you will probably encounter the following error:

Source server: The Migration Wizard cannot continue because the DSO client is not installed on this computer. Close the current Migration Wizard, install the DSO client on the computer, and then try running the Migration Wizard again.



The problem is that it tells you to use a tool that does not come with a vanilla install of SQL Server 2008. In fact, it takes a little digging to find this mysterious DSO client. The reason for this is that the component that lets you migrate from AS 2000 to 2008 was made for SQL Server 2005, and they did not upgrade it for SQL Server 2008. The good news is that even though it was made for SQL Server 2005, it works with SQL Server 2008 anyway. Go to this link:

http://www.microsoft.com/download/en/details.aspx?id=15748

Scroll down to find the Microsoft SQL Server 2005 Backward Compatibility Components and download the appropriate version for your platform. This should solve the missing DSO client error from the Migration Wizard.