Spoiler
Hello!
At first glance, in 2020, the topic may not seem relevant. But the Axapta 2012 version is still quite popular, and many projects are still actively developing on this version. In addition, the information from the topic will be useful for those migrating to the latest version of Dynamics 365 FO.
Prerequisites
For about 4 years we have been successfully operating a bundle of MS Dynamics AX 2012 R2 with MS SQL Server 2012 SP3. But in new versions of SQL Server, there are a number of new features that we wanted to implement in ourselves (for example, the Query Store ). Plus, the life cycle of the 2012 version comes to an end in 2022. Therefore, brute force engineering principle "works - do not touch", we decided to migrate our database to a more recent version of the DBMS.
At the time of the start of the project, the version of SQL Server 2017 was already quite mature, and version 2019 was recently released. But we were imposed by the version of our application software Dynamics AX 2012 R2. Microsoft guaranteed its stable operation only with version 2016. Therefore, we migrated to the version of SQL Server 2016. But the migration plan and the rake that we collected along the way will also be relevant when migrating to older versions for MS Dynamics AX 2012 R3 and Dynamics 365 FO ...
Migration plan
24\7. . . , Always on. 5 , .
:
|
| |
1 |
|
|
a. ( ) | 10 | |
b. CHECKDB | 12 | |
2 |
| 10 |
3 |
| 10 |
4 | (2 ). | 45 |
5 |
| 10 |
. .1 | ||
6 | (2 ) | 45 |
7 |
| 10 |
. .1 | ||
8 | Always On | 5 |
9 |
| 10 |
. .1 | ||
10 |
| 24 |
. .2 | ||
11 | ! , (2 ) | 45 |
12 |
| 10 |
. .1 | ||
13 | , | 5 |
14 |
| 10 |
. .1. | ||
15 |
| 10 |
16 | 2016 | 10 |
|
| ||
1 |
|
| |
1. | 10 | ||
2. WITH NORECOVERY | 12 | ||
3. | 10 | ||
2 |
|
| |
1. , | 5 | ||
2. | 10 | ||
3. SQL Server |
| ||
a. SQL Server , SQL Server | 1 | ||
b. WITH NORECOVERY | 12 | ||
c. | 10 | ||
4. 2 . |
| ||
11 , - , . , .
. , . , , . . , . .
, , , . «», . , . «» , . .
, . . – . , .
, SQL Server trace flag – . MS . . .
. 2012- . , !!!, , SQL Server 2014. , , .
, . – . Cardinality Estimator. , SQL Server 7.0.
, SQL Server 2014 . , , 120 ( , 2014 – 120). 2016 130, 120
, , SQL Server , – , . , , SQL Server 7.0, .
, . 90-. , .
, SQL Server ( ) . LEGACY_CARDINALITY_ESTIMATION. 1.
, «».
, , D365 FO. , , . Azure SQL , . . , , .
MS . . , - . change log upgrade-.