November 8, 2005 at 10:02 pm
I m in the process of migrating my data warehouse from developer server to the production server. I had successfully migrated all the database objects including DTS packages. But i m unable to migrate Cubes.
Is there any way to migrate cube from one server to another?
Regards
Shakeel
November 9, 2005 at 12:37 am
Have you tried backup and restore. In analysis services on your dev server right click the cube database and shoose something like 'archive database'. This makes a CAB file. On the live server you can then restore from archive and point to the cab file.
Hope this helps
November 9, 2005 at 4:01 am
Thanks!!!
It worked.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply