Post reply

exporting an analysis service db from one server to another

  • November 14, 2006 at 4:26 am

    #171269

    how do i export an analysis services from one server to another? i recently upgraded from analysis services 2000, so i didnt create the analysis services database and cubes in server 2005. Remember how you could save your db in analysis server 2000 as a cab file. is there any way to do that in analysis server 2005, so that i could simply then copy teh file over to a new server and add it?

     

  • November 14, 2006 at 8:29 pm

    #671827

    If you're looking to go from AS2005 to AS2005 then you can simply backup the database and restore it to the other server.  Backup and Restore work in a very similar fashion to traditional SQL database backup/restore.  In SS Management Studio, right click on the dtabase you want to back up and select BackUp.

     

    Steve.

  • November 14, 2006 at 8:30 pm

    #671828

    Another option that I've been keen to try out but haven't yet is the Synchronize option, i think this is meant to let you synchronize one DB to another server in the same network.

    Steve.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply