| title | Are you upgrading from SQL Server 2005? | Microsoft Docs | |
|---|---|---|
| ms.custom |
|
|
| ms.date | 03/01/2017 | |
| ms.prod | sql-server-2016 | |
| ms.reviewer | ||
| ms.suite | ||
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | article | |
| ms.assetid | ad40e66f-71fe-4ee6-9ce3-17127e7b1d7a | |
| caps.latest.revision | 21 | |
| author | MikeRayMSFT | |
| ms.author | mikeray | |
| manager | jhubbard |
The end of extended support for SQL Server 2005 is one reason to upgrade now to a newer version of SQL Server and to Azure SQL Database. Upgrading enables you to maintain security and compliance, achieve breakthrough performance, and optimize your data platform infrastructure.
For more info, guidance, and tools to plan and automate your upgrade or migration, see SQL Server 2005 end of support.
Important
Extended support for SQL Server 2005 ends on April 12, 2016. If you're still running SQL Server 2005 after April 12, 2016, you'll no longer receive security updates.
To get a data sheet in PDF format that explains the benefits of upgrading from SQL Server 2005, click here (not on the thumbnail image below).
If you’re upgrading relational databases from SQL Server 2005, here are your options for relational storage on the Microsoft platform.
To see a more comprehensive analysis of these options, click here.
| Relational storage option | Benefits | Other factors to consider |
|---|---|---|
| SQL Server on premises Consider this option for database applications of any kind, from transactional systems to data warehouses. |
You have the most control over features and scalability because you manage both hardware and software. If you’re upgrading from SQL Server 2005, this is the most similar environment. |
You have to make the biggest up-front investment and provide the most ongoing management, because you have to buy, maintain, and manage your own hardware and software. For more information, see SQL Server 2016. |
| SQL Server hosted on Azure virtual machines Consider this option if you want the following: Benefits of migrating to a hosted environment. Control over the operating environment. Familiar feature set of SQL Server. |
You can deploy quickly from a library of virtual machine images. You get the full SQL Server feature set. You save the cost of hardware and of server software. You pay only for hourly usage. |
You have to configure and manage both the SQL Server and the operating system software. For more information, see SQL Server on Azure Virtual Machines overview. For info about migrating, see Migrate a database to SQL Server on an Azure VM. |
| Azure SQL Database hosted database service Consider this option if you want a lower-cost solution with less maintenance. This option is particularly well suited for apps that don’t require the same capacity at all times, or that have to provide external access. |
You can deploy quickly and scale up easily. You pay only for hourly usage. The cost of the service includes not only storage, but high availability and automated backups. |
Azure SQL Database lacks some SQL Server features that are not applicable in a hosted cloud environment. For more info, see Azure SQL Database Transact-SQL information. Azure SQL Database also has a maximum database size of 500 GB, compared to 524 PB for SQL Server. For more information, see SQL Database. For information about migrating, see Migrating a SQL Server database to Azure SQL Database. |
You may also want to consider a non-relational or NoSQL solution for certain data and applications.
| Non-relational solution | Benefits |
|---|---|
| Azure DocumentDB Consider this option for modern, scalable, mobile and web applications that use JSON data and require a combination of robust querying and transactional data processing. For more info, see DocumentDB. For info about importing data, see Import data to DocumentDB. |
Your documents are indexed and you can use familiar SQL syntax to query them. The database is schema-free. You can add properties to documents without having to rebuild indexes. You get JSON and JavaScript support right inside the database engine. You get native support for geospatial data and integration with other Azure Services including Azure Search, HDInsight, and Data Factory. You get low latency, high performance storage with reserved throughput levels. |
| Azure table storage Consider this option to store petabytes of semi-structured data in a cost-effective solution. For more info, see Table Storage. |
You can evolve your apps and your table schema without taking the data offline. You can scale up without sharding your dataset. You get geo-redundant storage that replicates data across multiple regions. |
To download the report "Migrating from SQL Server 2005" by Directions on Microsoft, which contains more details about the upgrade options, click here (not on the thumbnail image below).
-
Read about how to plan your upgrade in the following series of blog posts from the SQL Server team.
-
Review the requirements and considerations under Planning a SQL Server Installation, including the Hardware and Software Requirements for Installing SQL Server 2016.
-
Read about how to upgrade.
-
Review the available upgrade methods and learn how to plan and test in the topic Upgrade Database Engine.
[!IMPORTANT]
You can't upgrade a SQL Server 2005 server to a SQL Server 2016 server in place. You have to install SQL Server 2016, then migrate your SQL Server 2005 databases to the new installation. For more info, see the section "New Installation Upgrade" in the topic Choose a Database Engine Upgrade Method. -
To get the more detailed "Technical Upgrade Guide" in PDF format, click here.
[!NOTE]
This is currently the SQL Server 2014 version of the "Technical Upgrade Guide". The SQL Server 2016 version of the guide is not yet available.
-
-
For more info, guidance, and tools to plan and automate your upgrade or migration, see SQL Server 2005 end of support.
To download an evaluation copy of SQL Server 2016, click here.
SQL Server 2016
SQL Server 2005 end of support
Upgrade from SQL Server 2005 to SQL Server 2014