Migrate from SSAS 2012 to SSAS 2019

Question

MS Techie 2,751

1) How to migrate an SSAS 2012 Cube to SSAS 2019 Cube. ?

Can we migrate directly from SSAS 2012 to SSAS 2019 or should we first migrate to SSAS 2017 and then to SSAS 2019.

2) What features of SSAS 2012 of MDX Cubes are not supported in SSAS 2019 ?

Please help

Accepted answer

1 additional answer

Answer 1

Lukas Yu -MSFT 5,826

Hi,

You do not need to intermediately upgrade to 2017 version, a direct upgrade is supported.
1. There are some discountinued/deprecieated features , for your reference, and they are listed at : Deprecated features SQL Server 2016 and SQL Server 2017 Deprecated features.

Regards,
Lukas

Lukas Yu -MSFT 5,826 Reputation points

2021-05-17T01:56:02.077+00:00

Did this help ? Feel free to let us know if you need further assist.
MS Techie 2,751 Reputation points

2021-05-17T12:13:33.053+00:00

Hi @Lukas Yu -MSFT

In comparison of SQL 2012 to SQL 2019, what features have changed with respect to SQL 2012's SSAS
Olaf Helper 47,441 Reputation points

2021-05-17T12:43:47.943+00:00

See What's New in SQL Server Analysis Services, there are all changes per version listed.
Lukas Yu -MSFT 5,826 Reputation points

2021-05-18T02:11:56.23+00:00

Hi,

From SSAS 2012 to SSAS 2019, the depreciated the features are the combination of the two lists I gave in my first post. You could click into the links and the lists are there, since they are plenty changes so I'd better not copy them all here.
Lukas Yu -MSFT 5,826 Reputation points

2021-05-31T02:54:15.8+00:00

Have you resolve this issue? Could we assist further?

Answer 2

Olaf Helper 47,441

1) You can do an in-place upgrade of the existing installation: Upgrade SQL Server => Analysis Services
You can upgrade directly from 2012 to 2019, see Supported version & edition upgrades (SQL Server 2019)

2) I am not aware of any changes in multidimension databases / MDX