Updated: May 31, 2023 (December 27, 2021)

SQL Server 2012 Migration Options

Andrew analyzes and writes about Microsoft's data management, business intelligence, and machine learning solutions, as well as aspects of licensing... more

Organizations should already have plans to migrate from SQL Server 2012, which reaches the end of Extended support in July 2022.
Extended Security Updates can prolong the life of SQL Server 2012 instances for an additional three years, but use cases are limited.
The hardest migration decision will be the destination, which determines compatibility, future cost, and support.
Robust backward compatibility and migration tools can help minimize changes and reduce disruptions.

SQL Server 2012 will leave Extended support in July 2022. Remaining on a version past Extended support introduces risks because Microsoft will generally not fix security vulnerabilities. This report covers the migration and upgrade options for SQL Server relational databases and database server instances, the most used SQL Server components.

Other SQL Server components, Analysis Services, Reporting Services, and Integration Service, can also influence migration plans and add to the complexity of decision making. (For migration options on those components, see the sidebars “SQL Server 2012 BI Migration Options” and “SQL Server 2012 Integration Services Migration Options.”)

Atlas Members have full access

Get access to this and thousands of other unbiased analyses, roadmaps, decision kits, infographics, reference guides, and more, all included with membership. Comprehensive access to the most in-depth and unbiased expertise for Microsoft enterprise decision-making is waiting.

Membership Options

Already have an account? Login Now