question

MSTechie-7364 avatar image
0 Votes"
MSTechie-7364 asked LukasYu-msft commented

Migrate from SSAS 2012 to SSAS 2019


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

sql-server-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

LukasYu-msft avatar image
0 Votes"
LukasYu-msft answered LukasYu-msft commented

Hi,


  1. You do not need to intermediately upgrade to 2017 version, a direct upgrade is supported.


  2. 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

· 5
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Did this help ? Feel free to let us know if you need further assist.

0 Votes 0 ·

Hi @LukasYu-msft

In comparison of SQL 2012 to SQL 2019, what features have changed with respect to SQL 2012's SSAS

0 Votes 0 ·

See What's New in SQL Server Analysis Services, there are all changes per version listed.


0 Votes 0 ·

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.

0 Votes 0 ·

Have you resolve this issue? Could we assist further?

0 Votes 0 ·
OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered

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

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.