Moving Analysis Server Model into Production Environment

[mroomi]

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

[v-sihou-msft]

@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]

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.