sql server data warehouse: import a cube created in AS 2000 into SSAA 2005 -- sql server data warehouse

import a cube created in AS 2000 into SSAA 2005

maddog
8/16/2006 8:58:33 AM

sql server data warehouse:

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

Re: import a cube created in AS 2000 into SSAA 2005

Jeje
8/20/2006 5:02:02 PM

there is no import option
you can try to upgrade your AS2000 server to AS2005.
install AS2000 on a new server, restore your databases and try to upgrade.
if you are a lucky man, then the install can upgrade the cubes, if not, then
there is no choice, you must recreate your cubes.

and, personnaly, I recommend a complete redesign of the cubes because there
is a lot of changes between the 2 versions.
this takes some times, but insure that your cubes will works fine and take
adavnatge of the new capabilities.

[quoted text, click to view]