Forum Discussion

littlemojopuppy's avatar
littlemojopuppy
Icon for Community Champion rankCommunity Champion
6 years ago
Solved

TEST/PROD deployment of Tabular Data Model

Good afternoon!  Would like to ask for some help with something...this may not even be the right forum for my question.

 

I've created an Azure Analysis Services data model pointed at Production data.  I would like to modify this data model in so that it can point at TEST data and deploy to a TEST AAS database while also still pointing at PROD data and deploy to a PROD AAS database.  Actual deployment of the model to either server should be manual...data refresh on the PROD server is already automated through Azure, and I'm fine with manually refreshing Test data in the model.

 

I've been Googling for a couple hours and looking at what I could find.  It seems that the Configuration Manager might be a means to accomplish this.  I could set up a Development and Production configuration, and each config would point at the appropriate data source and AAS database.  But I'm not positive this is what I need to do.

 

Does anyone have any advice or able to point me to any resources to help me figure out the best way to accomplish this without creating a duplicate version of the data model.  I don't want to have to reconcile changes in TEST to PROD unless that is the only way to get this done.

 

Thank you!  ðŸ™‚

2 Replies