Migrate Analysis Services 2000 OLAP cubes to SSAS 2008

I need to upgrade some OLAP cubes from SQL Server 2000 to SSAS 2008. Is there any way to migrate directly from SSAS or do I need to re-create every OLAP into SSAS 2008?
gosi75Business Intelligence ConsultantAsked:
Who is Participating?
 
AmmarRCommented:
no files,

while installing SQL server 2008, you will have the option to install or upgrade

i recommend using the SQL Server 2008 Upgrade Advisor tool, it will show you all the important issue.

you can download it from
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=f5a6c5e9-4cd9-4e42-a21c-7291e7f0f852&displaylang=en.

but for you ETLs, it depends alot on what logic is there.

its going to be a manual process, this is if you have ETLs running daily...
0
 
AmmarRCommented:
Analysis Services 2000 OLAP cubes to SSAS 2008 is a direct upgrade, no hard work,

but you might need to upgrade and rework your DTSs, ETLs
0
 
Alpesh PatelAssistant ConsultantCommented:
Hi,

You can also upgrade your ETL and DTS packages also.
0
 
gosi75Business Intelligence ConsultantAuthor Commented:
What steps do I need to do for that?
Which files do I need to copy from the sql server 2000 analysis services so SSAS can upgrate?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.