🔄
SQL Server 2016 Migration Planning
End of Extended Support: July 14, 2026
ACTION REQUIRED
⚠️

### SQL Server 2016 End of Extended Support

All SQL Server 2016 instances must be migrated before the deadline to maintain security compliance and receive critical updates.

July 14, 2026
Deadline
-- days remaining
🗄️
--
SQL 2016 Servers
Requiring Migration
🔴
--
Production
High Priority
🟢
--
Dev/Test
Migrate First
⚡
--
Tier 1 - CriminalJustice
Critical Systems
💼
--
Enterprise Edition
Licensing Review

### 📅 Suggested Migration Timeline

Phase 1
Jan - Feb 2026
Dev/Test Environments
Phase 2
Mar - Apr 2026
Tier 3 & 4 Production
Phase 3
May - Jun 2026
Tier 1 & 2 Production
Deadline
July 14, 2026
End of Support

### 🔴 Production SQL 2016 Servers --

Loading production servers...

### 🟢 Dev/Test SQL 2016 Servers --

Loading dev/test servers...

### 📊 Summary by Security Tier

Loading tier summary...

### ✅ Recommended Next Steps

1 Inventory Deep Dive

Run multi-server query from CMS to collect databases, logins, jobs, and linked servers.

2 Stakeholder Identification

Review SQL Agent job owners and database owners for application contacts.

3 Compatibility Assessment

Run Microsoft DMA on each server for SQL 2019/2022 compatibility issues.

4 Target Version Decision

Choose between SQL 2019 (stable) or SQL 2022 (latest). Consider Azure SQL options.

5 Migration Strategy

Determine method: in-place upgrade, side-by-side, backup/restore, or AG cutover.

6 Test Environment First

Begin with test pairs to validate migration process before production.