Are you upgrading from SQL Server 2005?

THIS TOPIC APPLIES TO: yesSQL Server (Windows only)noAzure SQL DatabasenoAzure SQL Data WarehousenoParallel Data Warehouse

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.

Why upgrade?


Extended support for SQL Server 2005 ended on April 12, 2016. If you're still running SQL Server 2005 after April 12, 2016, you no longer receive security updates.

Choose your upgrade option

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.
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 Cosmos DB

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 Cosmos DB.

For info about importing data, see Import data to Cosmos DB.
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.

Plan your upgrade

Get SQL Server

To download an evaluation copy of SQL Server, click here.

Next Steps

SQL Server 2017
SQL Server 2005 end of support