Migrating Tabular model with compatibility level 1100 to Azure Analysis Services

Question

We are trying to migrate a tabular model with compatibility level 1100 to AAS. I understand from the documenteation that a model with compatibility level of 1200 or above can be migrated to AAS. For Compatibility level below 1200, can we take the following approach: Migrate model with compatibility level 1100 to SQL Server 2016, change the compatibility level to 1200 and then migrate to AAS? Or is there a simpler way for doing the migration?
Thanks in advance!

Answer 1

Hi @Azure-Data-Guy ,

Thank you for your post.

Do you save the SSAS solution? If yes, you could change the compatibility level and the deployment server in visual studio, and then deploy to AAS. Please noted that before you change the compatibility level, you should back up the solution, because the compatibility level cannot change back to lower level.

Best regards,
Carrin

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Hey,
You can upgrade the compatibility using VS as mentioned in the below links:

https://social.msdn.microsoft.com/Forums/en-US/09a194e0-fffa-4ef1-b8ba-a9a2edf054ea/tabular-model-upgrading-to-compatibility-level-1500?forum=AzureAnalysisServices

mssqltips.com/sqlservertip/4214/how-to-change-compatibility-level-of-a-ssas-tabular-database-using-ssdt/