none
exporting an analysis server db from one server to another RRS feed

  • Question


  • 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?

     

    Tuesday, November 14, 2006 11:28 AM

Answers

  • In BI-Dev studio there is a project/template where you can import and generate scripts for that SSAS2005 cube to a project/script. If you successfully import this you will have scripts that you can deploy to a second server.

    The other way is the Deployment Wizard, under start/programs/sql server 2005/Analysis services. This wizard requires a SSAS2005 project.

    HTH

    Thomas Ivarsson

    Tuesday, November 14, 2006 2:04 PM
    Moderator
  • If you simply trying to create a project based on the existing cubes, you can simly go into BI Dev studio and create new project using "Import Analysis Services 9.0 database" project type.

    Edward Melomed.
    --
    This posting is provided "AS IS" with no warranties, and confers no rights.

    Tuesday, November 14, 2006 5:26 PM

All replies

  • In BI-Dev studio there is a project/template where you can import and generate scripts for that SSAS2005 cube to a project/script. If you successfully import this you will have scripts that you can deploy to a second server.

    The other way is the Deployment Wizard, under start/programs/sql server 2005/Analysis services. This wizard requires a SSAS2005 project.

    HTH

    Thomas Ivarsson

    Tuesday, November 14, 2006 2:04 PM
    Moderator
  • my problem is trying to get the cubes as a SSAS2005 project. they are deployed using 2005, but just cant get them as a project.
    Tuesday, November 14, 2006 5:16 PM
  • Have you started BI-Dev Studio and tried the template I have described?

    Regards

    Thomas Ivarsson

    Tuesday, November 14, 2006 5:19 PM
    Moderator
  • If you simply trying to create a project based on the existing cubes, you can simly go into BI Dev studio and create new project using "Import Analysis Services 9.0 database" project type.

    Edward Melomed.
    --
    This posting is provided "AS IS" with no warranties, and confers no rights.

    Tuesday, November 14, 2006 5:26 PM