Friday, February 24, 2012

Importing AS 2000 cube into SSAS 2005

Is there any way to import a cube created in AS 2000 into SSAA 2005? If not a direct import is there any way to make that job easier? Any suggestions/pointer/comments would be helpful.

I have a lot of AS 2000 cubes and I am really sick of that development environment!

You can use the Migration Wizard (search for MigrationWizard.exe in the SQL installation folder, or right click on the server node in SQL Management Studio and use 'Migrate ...'). The wizard requires AS2000 to be running and can generate a migration script (that can be later run on AS2005 with SQL Management Studio) or can migrate directly to AS2005.

You cannot restore AS2000 backup files (.cab) on AS2005.

Adrian Dumitrascu

No comments:

Post a Comment