Forum Discussion

mroomi's avatar
mroomi
Helper II
10 years ago

Moving Analysis Server Model into Production Environment

Hi, I have developed a model in our staging server and now trying to move it in to the production environment (Its another Analysis sevrer Box).  What is the best way and industry standard to do th...
Need Help
v-sihou-msft's avatar
v-sihou-msft
Microsoft Employee
10 years ago

mroomi

 

According to your description, do you want to move a SSAS database to another SSAS server?

 

To move a SSAS database, there's no so called "standard". You can just detach the database, then attach it onto another SSAS server. Or you can deploy your source SSAS project onto that new destination server in SSDT. For more details, please refer to links below:

 

Move an Analysis Services Database

Migration Considerations (Analysis Services)

 

Regards,

  • mroomi's avatar
    mroomi
    Helper II
    10 years ago

    Thanks Simon_Hou,

    But what if I just deployed all of my views and queries to production environment and then move the Analysis Server Model to the new production server, will it work?

     

    Just by moving the database will not move all of my measures into the new server.

     

    My stagign environemnt is connected to Staging database and production will be to production data. that is the reason I do not want to move the database, but I would like to move the model.