September 16, 2007 at 12:04 am
Hello,
We are having SQL Server 2000 database and cubes in Analysis Server 2000 and planning to migrate the database to SQL Server 2005 and cubes to analysis server 2005.
If anybody has gone through this excercise, please help me.
Thanks in advance.
Asif
September 17, 2007 at 9:49 am
What help are you looking for? Have you tried the migration wizard?
The SQL Server migration should be realtively straight forward. For MSAS, there's significant changes and advancements, so plan on some additional time to make other improvements. Much will depend on the complexity of the existing MSAS cubes.
September 18, 2007 at 10:09 am
Plan on just redeveloping your cubes in SSAS 2005. There is not a straightforward migration path.
Also, if you're using DTS for ETL, plan on redeveloping that in SSIS as well. It is possible to run DTS within the SSIS runtime but the advances in SSIS are so great, it'll benefit you in the longrun to just recreate them.
September 24, 2007 at 1:17 am
I agree with Chris. The migration wizard "may" get the cube across but when you start to edit it you'll find its done a shoddy job of it, Hirerachy and level names may have changed etc.
September 25, 2007 at 6:36 am
You can run the migration wizard and it will "probably" work, but you will end up with a lot of garbage. Because of the structural differences in AS2005, you really need to re-design your cubes.
Take the time to put your fact tables into a single cube where appropriate, and make sure you spend time setting up attribute relationships correctly or you will suffer performance problems.
If you have not worked with AS2005 before, it is very different from AS2000 and you should at least read a book on it. I would also suggest you get the documentation from Project REAL as it will be helpful in design and implementation.
January 14, 2008 at 11:35 am
🙂
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply