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?
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
|||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.|||Have you started BI-Dev Studio and tried the template I have described?
Regards
Thomas Ivarsson
|||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.
