Hi All,
I’m planning to migrate all our SQL Servers to the latest
version i.e., SQL Server 2019.
Below are the different
approaches I’m planning to follow for migrating AG and Cluster servers:
For AG servers, The OS version is Windows server 2012.
Hence, In-Place upgrade to SQL Server 2019 is not possible. So for AG servers
preferred migration approach is ‘Side by Side’.
For Cluster Server, The OS version is Windows Server 2016.
Hence, In-Place upgrade to SQL Server 2019 is possible. So for Cluster servers
preferred migration approach is ‘In-Place upgrade’
|
Server Name |
OS Version |
SQL Server Version |
Cluster/AG |
Preferred Migration Method |
Target SQL Server Version |
|
NSC-SP-SQLCLS1 |
Windows Server 2016 |
SQL Server 2014 |
Cluster |
In-Place Upgrad |
SQL Server 2019 |
|
NSC-SP-SQLCLS2 |
Windows Server 2016 |
SQL Server 2014 |
Cluster |
In-Place Upgrad |
SQL Server 2019 |
|
SSC-SP-SQLCLS1 |
Windows Server 2016 |
SQL Server 2014 |
Cluster |
In-Place Upgrad |
SQL Server 2019 |
|
SSC-SP-SQLCLS1 |
Windows Server 2016 |
SQL Server 2014 |
Cluster |
In-Place Upgrad |
SQL Server 2019 |
|
SP13-PRD-SQLSVC |
Windows Server 2012 |
SQL Server 2014 |
Always ON |
Side by Side |
SQL Server 2019 |
|
SP13-LAB-SQLSVC |
Windows Server 2012 |
SQL Server 2014 |
Always ON |
Side by Side |
SQL Server 2019 |
Below are the plans for
Side by Side and In-Place migration:
Plan for Side By Side
upgrade for AG servers:
- 1. Build the new servers with Window server 2016 OS and similar configurations as old server(Drives, Memory, CPU)
- 2. Install the SQL Server failover cluster manager on both the nodes
- 3. Add the nodes to cluster
- 4. Install the SQL Server 2019 on each node
- 5. Enable Always On availability groups feature in configuration manager on each node
- 6. Configure Always on availability groups
- 7. Configure Listener
- 8. Migrate the databases, logins, jobs, linked servers and other objects if any from old server to new server
- 9. Change the server name to new name in application connection string – Application Team
Plan of In-Place
upgrade for Cluster servers:
- 1. Take the backup of all database
- 2. Take a snapshot of VM if possible
- 3. Copy the SQL Server 2019 enterprise edition software on each node
- 4. Perform the SQL Server in-place upgrade on secondary node
- 5. Once upgrade successful on secondary node, perform the failover .
- 6. Now do the In-place upgrade on current secondary node
- 7. After the upgrade, check the application functionality.
If the above plan is okay then soon I’ll share the schedule
for each server.
Please let me know if you have any questions or concerns.
