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

 

Thanks,

Roomi

Need Help

2 Replies

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