How to upgrade SSAS cube build on SQL server 2008 to work and deploy on SQL server 2019

Praveen Saini 21 Reputation points
2022-11-17T10:18:49.847+00:00

what steps can be taken to upgrade SSAS cube build on SQL server 2008 R2 to work and deploy on SQL server 2019?

SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,242 questions
0 comments
Accepted answer
  1. Joyzhao-MSFT 15,566 Reputation points
    2022-11-18T03:31:15.163+00:00

    Hi @Praveen Saini ,
    If I understand correctly, you should need to backup and restore the current database. Since you are upgrading from SQL Server 2008, you also need to update the database compatibility level at the same time.
    See more: SQL Server Analysis Services Migration.
    Best Regards,
    Joy

    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.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest