Actualizaciones de ediciones y versiones admitidasSupported Version and Edition Upgrades

SE APLICA A: síSQL Server (solo en Windows) noAzure SQL Database noAzure SQL Data Warehouse noAlmacenamiento de datos paralelos APPLIES TO: yesSQL Server (Windows only) noAzure SQL Database noAzure SQL Data Warehouse noParallel Data Warehouse

Puede actualizar de SQL Server 2008SQL Server 2008, SQL Server 2008 R2SQL Server 2008 R2, SQL Server 2012 (11.x)SQL Server 2012 (11.x)y SQL Server 2014 (12.x)SQL Server 2014 (12.x).You can upgrade from SQL Server 2008SQL Server 2008, SQL Server 2008 R2SQL Server 2008 R2, SQL Server 2012 (11.x)SQL Server 2012 (11.x), and SQL Server 2014 (12.x)SQL Server 2014 (12.x). En este artículo se enumeran las rutas de actualización admitidas desde estas versiones de SQL ServerSQL Server y las actualizaciones de edición admitidas para SQL Server 2016 (13.x)SQL Server 2016 (13.x).This article lists the supported upgrade paths from these SQL ServerSQL Server versions, and the supported edition upgrades for SQL Server 2016 (13.x)SQL Server 2016 (13.x).

Lista de comprobación previa a la actualizaciónPre upgrade Checklist

  • Antes de actualizar una edición de SQL Server 2016 (13.x)SQL Server 2016 (13.x), compruebe que las funciones que utiliza se admiten en la edición a la que va a cambiar.Before upgrading from one edition of SQL Server 2016 (13.x)SQL Server 2016 (13.x) to another, verify that the functionality you are currently using is supported in the edition to which you are moving.

  • Antes de actualizar a SQL ServerSQL Server, habilite la autenticación de Windows para el Agente SQL ServerSQL Server y compruebe la configuración predeterminada: la cuenta de servicio del Agente SQL ServerSQL Server debe ser miembro del grupo sysadmin de SQL ServerSQL Server.Before upgrading SQL ServerSQL Server, enable Windows Authentication for SQL ServerSQL Server Agent and verify the default configuration: that the SQL ServerSQL Server Agent service account is a member of the SQL ServerSQL Server sysadmin group.

  • Para actualizar a SQL Server 2016 (13.x)SQL Server 2016 (13.x), debe ejecutar un sistema operativo admitido.To upgrade to SQL Server 2016 (13.x)SQL Server 2016 (13.x), you must be running a supported operating system. Para obtener más información, vea Requisitos de hardware y software para instalar SQL Server 2016.For more information, see Hardware and Software Requirements for Installing SQL Server 2016.

  • La actualización se bloqueará si hay un reinicio pendiente.Upgrade will be blocked if there is a pending restart.

  • La actualización se bloqueará si el servicio de Windows Installer no se está ejecutando.Upgrade will be blocked if the Windows Installer service is not running.

Escenarios no admitidosUnsupported Scenarios

  • No se admiten instancias de SQL Server 2016 (13.x)SQL Server 2016 (13.x) de distintas versiones.Cross-version instances of SQL Server 2016 (13.x)SQL Server 2016 (13.x) are not supported. Los números de versión de Motor de base de datosDatabase Engine, Analysis ServicesAnalysis Servicesy Reporting ServicesReporting Services deben ser los mismos en una instancia de SQL Server 2016 (13.x)SQL Server 2016 (13.x).Version numbers of the Motor de base de datosDatabase Engine, Analysis ServicesAnalysis Services, and Reporting ServicesReporting Services components must be the same in an instance of SQL Server 2016 (13.x)SQL Server 2016 (13.x).

  • SQL Server 2016 (13.x)SQL Server 2016 (13.x) solo está disponible para plataformas de 64 bits.is only available for 64-bit platforms. No se admite la actualización entre plataformas.Cross-platform upgrade is not supported. No puede actualizar una instancia de 32 bits de SQL ServerSQL Server a 64 bits nativo con el programa de instalación de SQL ServerSQL Server.You cannot upgrade a 32-bit instance of SQL ServerSQL Server to native 64-bit using SQL ServerSQL Server Setup. Sin embargo, puede realizar copias de seguridad o separar bases de datos de una instancia de 32 bits de SQL ServerSQL Server y, después, si no están publicadas en replicación, restaurarlas o anexarlas a una nueva instancia de SQL ServerSQL Server (64 bits).However, you can back up or detach databases from a 32-bit instance of SQL ServerSQL Server, and then restore or attach them to a new instance of SQL ServerSQL Server (64-bit) if the databases are not published in replication. Debe volver a crear los inicios de sesión y los demás objetos de usuario en las bases de datos del sistema maestra, msdb y modelo.You must re-create any logins and other user objects in master, msdb, and model system databases.

  • No puede agregar características nuevas durante la actualización de una instancia existente de SQL ServerSQL Server.You cannot add new features during the upgrade of your existing instance of SQL ServerSQL Server. Después de actualizar una instancia de SQL ServerSQL Server a SQL Server 2016 (13.x)SQL Server 2016 (13.x), puede agregar características mediante el programa de instalación de SQL Server 2016 (13.x)SQL Server 2016 (13.x).After you upgrade an instance of SQL ServerSQL Server to SQL Server 2016 (13.x)SQL Server 2016 (13.x), you can add features by using the SQL Server 2016 (13.x)SQL Server 2016 (13.x) Setup. Para obtener más información, vea Agregar características a una instancia de SQL Server 2016 (programa de instalación).For more information, see Add Features to an Instance of SQL Server 2016 (Setup).

  • Los clústeres de conmutación por error no se admiten en el modo WOW.Failover Clusters are not supported in WOW mode.

  • La actualización de una edición de evaluación de una versión anterior de SQL ServerSQL Server no se admite.Upgrade from an Evaluation edition of a previous SQL ServerSQL Server version is not supported.

  • Al actualizar desde RC1 o desde una versión anterior de SQL Server 2016 a RC3 o a una versión posterior, PolyBase debe desinstalarse antes de la actualización y reinstalarse tras ella.When upgrading from RC1 or previous versions of SQL Server 2016 to RC3 or later versions, PolyBase must be uninstalled before the upgrade and reinstalled after the upgrade.

Actualizaciones de versiones anteriores a SQL Server 2016 (13.x)SQL Server 2016 (13.x)Upgrades from Earlier Versions to SQL Server 2016 (13.x)SQL Server 2016 (13.x)

SQL Server 2016 admite la actualización de las siguientes versiones de SQL Server:SQL Server 2016 supports upgrade from the following versions of SQL Server:

  • SQL Server 2008SQL Server 2008 SP4 o posteriorSP4 or later
  • SQL Server 2008 R2SQL Server 2008 R2 SP3 o posteriorSP3 or later
  • SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP2 o posteriorSP2 or later
  • SQL Server 2014 (12.x)SQL Server 2014 (12.x) o posterioror later

Nota

Para actualizar bases de datos en SQL Server 2005 (9.x)SQL Server 2005 (9.x) vea Compatibilidad con la versión 2005.To upgrade databases on SQL Server 2005 (9.x)SQL Server 2005 (9.x) see Support for 2005.

En la siguiente tabla se indican los escenarios de actualización de versiones anteriores de SQL ServerSQL Server a SQL Server 2016 (13.x)SQL Server 2016 (13.x)admitidos.The table below lists the supported upgrade scenarios from earlier versions of SQL ServerSQL Server to SQL Server 2016 (13.x)SQL Server 2016 (13.x).

Actualización deUpgrade from Ruta de actualización admitidaSupported upgrade path
SQL Server 2008SQL Server 2008 SP4 EnterpriseSP4 Enterprise SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise
SQL Server 2008SQL Server 2008 SP4 DeveloperSP4 Developer SQL Server 2016 (13.x)SQL Server 2016 (13.x) DeveloperDeveloper
SQL Server 2008SQL Server 2008 SP4 StandardSP4 Standard SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard
SQL Server 2008SQL Server 2008 SP4 Small BusinessSP4 Small Business SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard
SQL Server 2008SQL Server 2008 SP4 WebSP4 Web SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb
SQL Server 2008SQL Server 2008 SP4 WorkgroupSP4 Workgroup SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard
SQL Server 2008SQL Server 2008 SP4 ExpressSP4 Express SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb

SQL Server 2016 (13.x)SQL Server 2016 (13.x) ExpressExpress
SQL Server 2008 R2SQL Server 2008 R2 SP3 DatacenterSP3 Datacenter SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise
SQL Server 2008 R2SQL Server 2008 R2 SP3 EnterpriseSP3 Enterprise SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise
SQL Server 2008 R2SQL Server 2008 R2 SP3 DeveloperSP3 Developer SQL Server 2016 (13.x)SQL Server 2016 (13.x) DeveloperDeveloper
SQL Server 2008 R2SQL Server 2008 R2 SP3 Small BusinessSP3 Small Business SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard
SQL Server 2008 R2SQL Server 2008 R2 SP3 StandardSP3 Standard SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard
SQL Server 2008 R2SQL Server 2008 R2 SP3 WebSP3 Web SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb
SQL Server 2008 R2SQL Server 2008 R2 SP3 WorkgroupSP3 Workgroup SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard
SQL Server 2008 R2SQL Server 2008 R2 SP3 ExpressSP3 Express SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb

SQL Server 2016 (13.x)SQL Server 2016 (13.x) ExpressExpress
SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP2 EnterpriseSP2 Enterprise SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise
SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP2 DeveloperSP2 Developer SQL Server 2016 (13.x)SQL Server 2016 (13.x) DeveloperDeveloper

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb

SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise
SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP2 StandardSP2 Standard SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard
SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP1 WebSP1 Web SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb
SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP2 ExpressSP2 Express SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb

SQL Server 2016 (13.x)SQL Server 2016 (13.x) ExpressExpress

SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP2 Business IntelligenceSP2 Business Intelligence SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise
SQL Server 2012 (11.x)SQL Server 2012 (11.x) SP2 EvaluationSP2 Evaluation SQL Server 2016 (13.x)SQL Server 2016 (13.x) EvaluationEvaluation

SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb

SQL Server 2016 (13.x)SQL Server 2016 (13.x) DeveloperDeveloper
SQL Server 2014 (12.x)SQL Server 2014 (12.x) EnterpriseEnterprise SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise
SQL Server 2014 (12.x)SQL Server 2014 (12.x) DeveloperDeveloper SQL Server 2016 (13.x)SQL Server 2016 (13.x) DeveloperDeveloper

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb

SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise
SQL Server 2014 (12.x)SQL Server 2014 (12.x) StandardStandard SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard
SQL Server 2014 (12.x)SQL Server 2014 (12.x) WebWeb SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb
SQL Server 2014 (12.x)SQL Server 2014 (12.x) ExpressExpress SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb

SQL Server 2016 (13.x)SQL Server 2016 (13.x) ExpressExpress

SQL Server 2016 (13.x)SQL Server 2016 (13.x) DeveloperDeveloper
SQL Server 2014 (12.x)SQL Server 2014 (12.x) Business IntelligenceBusiness Intelligence SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise
SQL Server 2014 (12.x)SQL Server 2014 (12.x) EvaluationEvaluation SQL Server 2016 (13.x)SQL Server 2016 (13.x) EvaluationEvaluation

SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb

SQL Server 2016 (13.x)SQL Server 2016 (13.x) DeveloperDeveloper
SQL Server 2016 (13.x)SQL Server 2016 (13.x) versión candidata para lanzamiento*release candidate* SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise
SQL Server 2016 (13.x)SQL Server 2016 (13.x) DeveloperDeveloper SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise

* La compatibilidad de Microsoft para actualizar del software de la versión candidata para lanzamiento está destinado específicamente a los clientes que han participado en el Programa de adopción de tecnología (TAP).* Microsoft support to upgrade from release candidate software is specifically for customers who participated in the Technology Adoption Program (TAP).

SQL Server 2016 (13.x)SQL Server 2016 (13.x) Compatibilidad con SQL Server 2005 (9.x)SQL Server 2005 (9.x)SQL Server 2016 (13.x)SQL Server 2016 (13.x) Support for SQL Server 2005 (9.x)SQL Server 2005 (9.x)

En esta sección se explica la compatibilidad de SQL Server 2016 (13.x)SQL Server 2016 (13.x) con SQL Server 2005 (9.x)SQL Server 2005 (9.x).This section discusses SQL Server 2016 (13.x)SQL Server 2016 (13.x) support for SQL Server 2005 (9.x)SQL Server 2005 (9.x). En SQL Server 2016 (13.x)SQL Server 2016 (13.x), podrá hacer lo siguiente:In SQL Server 2016 (13.x)SQL Server 2016 (13.x), you will be able to do the following:

  • Adjuntar una base de datos de SQL Server 2005 (9.x)SQL Server 2005 (9.x) (archivos mdf/ldf) a la instancia de SQL Server 2016 (13.x)SQL Server 2016 (13.x) del motor de base de datos.Attach a SQL Server 2005 (9.x)SQL Server 2005 (9.x) database (mdf/ldf files) to SQL Server 2016 (13.x)SQL Server 2016 (13.x) instance of database engine.

  • Restaurar una base de datos de SQL Server 2005 (9.x)SQL Server 2005 (9.x) a la instancia de SQL Server 2016 (13.x)SQL Server 2016 (13.x) del motor de base de datos desde una copia de seguridad.Restore a SQL Server 2005 (9.x)SQL Server 2005 (9.x) database to SQL Server 2016 (13.x)SQL Server 2016 (13.x) instance of database engine from a backup.

  • Hacer copia de seguridad de un cubo de SQL Server 2005 Analysis Services (SSAS)SQL Server 2005 Analysis Services (SSAS) y restaurarla en SQL Server 2016 (13.x)SQL Server 2016 (13.x).Back up a SQL Server 2005 Analysis Services (SSAS)SQL Server 2005 Analysis Services (SSAS) cube and restoring on SQL Server 2016 (13.x)SQL Server 2016 (13.x).

Nota

Cuando una base de datos de SQL Server 2005 (9.x)SQL Server 2005 (9.x) se actualiza a SQL Server 2016 (13.x)SQL Server 2016 (13.x), el nivel de compatibilidad de la base de datos se cambia de 90 a 100.When a SQL Server 2005 (9.x)SQL Server 2005 (9.x) database is upgraded to SQL Server 2016 (13.x)SQL Server 2016 (13.x), the database compatibility level will be changed from 90 to 100. En SQL Server 2016 (13.x)SQL Server 2016 (13.x), los valores válidos del nivel de compatibilidad de la base de datos son 100, 110, 120 y 130.In SQL Server 2016 (13.x)SQL Server 2016 (13.x), valid values for the database compatibility level are 100, 110, 120, and 130. En el tema Nivel de compatibilidad de ALTER DATABASE (Transact-SQL) se explica cómo el cambio del nivel de compatibilidad puede afectar a las aplicaciones de SQL ServerSQL Server.ALTER DATABASE Compatibility Level (Transact-SQL) discusses how the compatibility level change could affect SQL ServerSQL Server applications.

Los escenarios no especificados en la lista anterior no se admiten, incluidos pero no limitados a lo siguiente:Any scenarios not specified in the list above are not supported, including but not limited to the following:

  • Instalar SQL Server 2005 (9.x)SQL Server 2005 (9.x) y SQL Server 2016 (13.x)SQL Server 2016 (13.x) en el mismo equipo (en paralelo).Installing SQL Server 2005 (9.x)SQL Server 2005 (9.x) and SQL Server 2016 (13.x)SQL Server 2016 (13.x) on same computer (side by side).

  • Usar una instancia de SQL Server 2005 (9.x)SQL Server 2005 (9.x) como miembro de la topología de replicación que incluye una instancia de SQL Server 2016 (13.x)SQL Server 2016 (13.x) .Using a SQL Server 2005 (9.x)SQL Server 2005 (9.x) instance as a member of the replication topology that involves a SQL Server 2016 (13.x)SQL Server 2016 (13.x) instance.

  • Configurar la creación de reflejo de la base de datos entre instancias de SQL Server 2016 (13.x)SQL Server 2016 (13.x) y SQL Server 2005 (9.x)SQL Server 2005 (9.x) .Configuring database mirroring between SQL Server 2016 (13.x)SQL Server 2016 (13.x) and SQL Server 2005 (9.x)SQL Server 2005 (9.x) instances.

  • Hacer copia de seguridad del registro de transacciones con trasvase de registros entre instancias de SQL Server 2016 (13.x)SQL Server 2016 (13.x) y SQL Server 2005 (9.x)SQL Server 2005 (9.x) .Backing up the transaction log with log shipping between SQL Server 2016 (13.x)SQL Server 2016 (13.x) and SQL Server 2005 (9.x)SQL Server 2005 (9.x) instances.

  • Configurar servidores vinculados entre instancias de SQL Server 2016 (13.x)SQL Server 2016 (13.x) y SQL Server 2005 (9.x)SQL Server 2005 (9.x) .Configuring linked servers between SQL Server 2016 (13.x)SQL Server 2016 (13.x) and SQL Server 2005 (9.x)SQL Server 2005 (9.x) instances.

  • Administrar una instancia de SQL Server 2005 (9.x)SQL Server 2005 (9.x) desde SQL Server 2016 (13.x)SQL Server 2016 (13.x) Management Studio.Managing a SQL Server 2005 (9.x)SQL Server 2005 (9.x) instance from a SQL Server 2016 (13.x)SQL Server 2016 (13.x) Management Studio.

  • Adjuntar un cubo de SQL Server 2005 Analysis Services (SSAS)SQL Server 2005 Analysis Services (SSAS) en SQL Server 2016 (13.x)SQL Server 2016 (13.x) Management Studio.Attaching a SQL Server 2005 Analysis Services (SSAS)SQL Server 2005 Analysis Services (SSAS) cube in SQL Server 2016 (13.x)SQL Server 2016 (13.x) Management Studio.

  • Conectarse a SQL Server 2005 Integration Services (SSIS)SQL Server 2005 Integration Services (SSIS) desde SQL Server 2016 (13.x)SQL Server 2016 (13.x) Management Studio.Connecting to SQL Server 2005 Integration Services (SSIS)SQL Server 2005 Integration Services (SSIS) from SQL Server 2016 (13.x)SQL Server 2016 (13.x) Management Studio.

  • Administrar un servicio de SQL Server 2005 Integration Services (SSIS)SQL Server 2005 Integration Services (SSIS) desde SQL Server 2016 (13.x)SQL Server 2016 (13.x) Management Studio.Managing a SQL Server 2005 Integration Services (SSIS)SQL Server 2005 Integration Services (SSIS) service from SQL Server 2016 (13.x)SQL Server 2016 (13.x) Management Studio.

  • Compatibilidad con componentes personalizados de terceros de Integration Services de SQL Server 2005 (9.x)SQL Server 2005 (9.x), por ejemplo de ejecución y actualización.Support for SQL Server 2005 (9.x)SQL Server 2005 (9.x) third party custom Integration Services components, such as execute and upgrade.

Actualización de la edición de SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2016 (13.x)SQL Server 2016 (13.x) Edition Upgrade

En la tabla siguiente se enumeran los escenarios de actualización de edición de SQL Server 2016 (13.x)SQL Server 2016 (13.x)admitidos.The following table lists the supported edition upgrade scenarios in SQL Server 2016 (13.x)SQL Server 2016 (13.x).

Para obtener instrucciones paso a paso sobre cómo realizar una actualización de edición, vea Actualizar a una edición diferente de SQL Server 2016 (programa de instalación).For step-by-step instructions on how to perform an edition upgrade, see Upgrade to a Different Edition of SQL Server 2016 (Setup).

Actualización deUpgrade From Actualización aUpgrade To
SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise (Server+CAL y Core)**Enterprise (Server+CAL and Core)** SQL Server 2016 (13.x)SQL Server 2016 (13.x) EnterpriseEnterprise
SQL Server 2016 (13.x)SQL Server 2016 (13.x) Evaluation Enterprise**Evaluation Enterprise** SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise (licencia Server+CAL o Core)Enterprise (Server+CAL or Core License)

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) DeveloperDeveloper

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb

La actualización de Evaluation (una edición gratuita) a cualquiera de las ediciones de pago se admite para las instalaciones independientes, pero no para las instalaciones en clúster.Upgrading from Evaluation (a free edition) to any of the paid editions is supported for stand-alone installations, but is not supported for clustered installations.
SQL Server 2016 (13.x)SQL Server 2016 (13.x) Standard**Standard** SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise (licencia Server+CAL o Core)Enterprise (Server+CAL or Core License)
SQL Server 2016 (13.x)SQL Server 2016 (13.x) Developer**Developer** SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise (licencia Server+CAL o Core)Enterprise (Server+CAL or Core License)

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard
SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise (licencia Server+CAL o Core)Enterprise (Server+CAL or Core License)

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard
SQL Server 2016 (13.x)SQL Server 2016 (13.x) Express*Express* SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise (licencia Server+CAL o Core)Enterprise (Server+CAL or Core License)

SQL Server 2016 (13.x)SQL Server 2016 (13.x) DeveloperDeveloper

SQL Server 2016 (13.x)SQL Server 2016 (13.x) StandardStandard

SQL Server 2016 (13.x)SQL Server 2016 (13.x) WebWeb

Además, también puede realizar una actualización de la edición entre SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise (licencia Server+CAL) y SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise (licencia Core):Additionally you can also perform an edition upgrade between SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise (Server+CAL license) and SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise (Core License):

Actualización de la edición desdeEdition Upgrade From Actualización de la edición aEdition Upgrade To
SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise (licencia Server+CAL)**Enterprise (Server+CAL License)** SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise (licencia Core)Enterprise (Core License)
SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise (licencia Core)Enterprise (Core License) SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise (licencia Server+CAL)Enterprise (Server+CAL License)

* También se aplica a SQL Server 2016 (13.x)SQL Server 2016 (13.x) Express with Tools y SQL Server 2016 (13.x)SQL Server 2016 (13.x) Express con Advanced Services.* Also applies to SQL Server 2016 (13.x)SQL Server 2016 (13.x) Express with Tools and SQL Server 2016 (13.x)SQL Server 2016 (13.x) Express with Advanced Services.

** El cambio de edición de un clúster de conmutación por error de SQL Server 2016 (13.x)SQL Server 2016 (13.x) está limitado.** Changing the edition of a SQL Server 2016 (13.x)SQL Server 2016 (13.x) failover cluster is limited. Los escenarios siguientes no se admiten en los clústeres de conmutación por error de SQL Server 2016 (13.x)SQL Server 2016 (13.x):The following scenarios are not supported for SQL Server 2016 (13.x)SQL Server 2016 (13.x) failover clusters:

  • SQL Server 2016 (13.x)SQL Server 2016 (13.x) Enterprise a SQL Server 2016 (13.x)SQL Server 2016 (13.x) Developer, Standard o Evaluation.Enterprise to SQL Server 2016 (13.x)SQL Server 2016 (13.x) Developer, Standard, or Evaluation.

  • SQL Server 2016 (13.x)SQL Server 2016 (13.x) Developer a SQL Server 2016 (13.x)SQL Server 2016 (13.x) Standard o Evaluation.Developer to SQL Server 2016 (13.x)SQL Server 2016 (13.x) Standard or Evaluation.

  • SQL Server 2016 (13.x)SQL Server 2016 (13.x) Standard a SQL Server 2016 (13.x)SQL Server 2016 (13.x) Evaluation.Standard to SQL Server 2016 (13.x)SQL Server 2016 (13.x) Evaluation.

  • SQL Server 2016 (13.x)SQL Server 2016 (13.x) Evaluation a SQL Server 2016 (13.x)SQL Server 2016 (13.x) Standard.Evaluation to SQL Server 2016 (13.x)SQL Server 2016 (13.x) Standard.

Consulte tambiénSee Also

Características compatibles con las ediciones de SQL Server 2016 Editions and Supported Features for SQL Server 2016
Requisitos de hardware y software para instalar SQL Server 2016 Hardware and Software Requirements for Installing SQL Server 2016
Actualizar a SQL Server 2016Upgrade to SQL Server 2016