Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Open Project from deployed database

Author  Topic 

shanmugaraj
Posting Yak Master

219 Posts

Posted - 2009-07-15 : 06:43:03
Hi,
I created an SSAS Project and deployed it in server. Later i made many changes in the deployed version of the Analysis Database by File --> Open--> Analysis Server database and selecting the required database.

Now my require an Project version of the updated Analysis Server database.

How can i convert an deployed SSAS database back to project.

THANKS IN ADVANCE.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-07-15 : 13:49:57
dont you have XMLA that you generated from project initially using deployment wizard? also, do you have a version control tool like SVN where you store the project files?
Go to Top of Page

shanmugaraj
Posting Yak Master

219 Posts

Posted - 2009-07-16 : 06:19:30
No. The project is not create by me actually. I have an deployed cube. I need to backtrack and get the project for it.

THANKS
SHANMUGARAJ
nshanmugaraj@gmail.com
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-07-16 : 14:00:08
then what you can do is script out dimensions,measure groups etc and then run it again to create project
Go to Top of Page
   

- Advertisement -