Post reply

Cube Migration

  • November 8, 2005 at 10:02 pm

    #111324

    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

    #602954

    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

    #602983

    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