June 5, 2007 at 3:18 pm
I have a cube in Analysis Services 2000 and it's processed, but the information is too old and there is database for reprocessing this cube. The users consult the historical data for their jobs. I need migrate this cube with the data that it contains (because the database don't exists for reprocessing). Is it possible?? Is there any tool for this activity???
Thanks a lot
June 8, 2007 at 5:00 am
There is a migration wizard "migrationwizard.exe" but dont hold your breath that it will work.
June 14, 2007 at 2:53 pm
Thanks a lot for your answer, but the migrationwizard only generate the cube structure but don't generate the data. Please help me.
June 14, 2007 at 3:26 pm
Microsloth has some good documentation on this...let me know how it goes. I'm getting ready to upgrade ours here also...
References
• Upgrading or Migrating Analysis Services (link)
• SQL Server 2005 Analysis Services Backward Compatibility (link)
• Known Upgrade Issues for SQL Server 2005 Analysis Services (link)
• Migrating Existing Analysis Services Databases (link)
Ben Sullins
bensullins.com
Beer is my primary key...
June 15, 2007 at 3:28 am
If you cant upgrade without destroying the original data in the cube there could be another option. Depending on the complexity you could MDX all the data out. I've done this previously in excel and DSO. I've generated a custom script to query a cube and populate an spreadsheet into a table format. Then put the result back in to a database table.
I suggested to Microsoft a few years ago they could develop a function that exports the contents of cube into a table but to no avail.
All the best.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply