January 21, 2010 at 12:18 am
Hi,
i would like to know if its possible to deploy a ssas 2000 cube on a 2008 server? will it work? will i have to do some sort of upgrade to the cube?
January 21, 2010 at 8:39 pm
Analysis Services had some big changes done to it between SQL 2000 and SQL 2005. From 2005 to 2008 there were more changes but not so major.
There is a migration wizard for AS2000 databases to convert them (you will see this wizard in Visual Studio as one of the BI Project types) to AS2005 or AS2008 "equivalent". I can't say that this alway produces the expected result, though.
Microsoft recommends that the AS database be re-developed. This may be a little more time consuming but you do get a much better result.
January 22, 2010 at 4:33 am
My experience converting multi-cube environment from 2000 onto 2005 back then:
I tried the wizard, it actually worked and the resulting SSAS database was operational.
But.... after I have played a bit with the 2005, etc, I concluded that the result of the conversion wizard was not any good and needed heaps of modifications.
The previous message is practically correct -- start a new project, mirror the dimensions, create cubes from scratch.
What the resulting project after the wizard helped me with was with calculations (we had heaps of calculations).
I copy-pasted the calculations from each cube onto the brand new cubes.
I had to modify quite a lot there , but the foundation was all there.
ps: with 2008 -- the same story
Hope it helps
VAL
M.Sc.IT, M.B.A, MCTS BI 2008, MCITP BI 2008, MCTS SQL Dev, CSM, CDVDM
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply