Versión e edición de partida no noso SQL Server 2017
Partimos dun escenario cunha versión RC SQLServer, previa á versión RTM, concretamente unha RC2 (Release Candidate 2). A edición é Enterprise Evaluation, con limitación temporal de uso.
1> :setvar SQLCMDMAXVARTYPEWIDTH 35
2> :setvar SQLCMDMAXFIXEDTYPEWIDTH 35
3> SELECT SERVERPROPERTY('productversion') as Version, SERVERPROPERTY ('productlevel') as Level ,SERVERPROPERTY ('edition') as Edition
4> go
Version Level Edition
----------------------------------- ----------------------------------- -----------------------------------
14.0.900.75 RC2 Enterprise Evaluation Edition (64-b
Posibilidades de upgrade de edición e versión SQL Server 2017
Podemos obter información sobre a actualización de edicións na web de Microsoft. Comprobamos que é posible pasar dunda Evaluation Enterprise a unha Developer.
En canto ás versións dende a que podemos facer un upgrade, nas release notes de SQL Server 2017 indícase que o upgrade é viable dende versión CTP 2.1, previa á RC2 da que partimos.
Polo tanto, a actualización que precisamos está dentro do soporte de Microsoft.
Actualización de RC2 (14.0.900.75) a RTM CU3 (14.0.3015.40)
Nesta instalación, precisamos comezar engadindo un novo repositorio, xa que para a instalación inicial foi empregado o CTP dispoñible no momento de liberación desta versión. Engadimos o repositorio CU (Cumulative Updates) que é o que nos interesa fronte o GDR que só inclúe a versión base e parches críticos (aproveito para agradecer ó colega Ignacio Vizoso por aportarme este punto ó procedemento de upgrade).
sudo curl -o /etc/yum.repos.d/mssql-server.repo https://packages.microsoft.com/config/rhel/7/mssql-server-2017.repo
Agora actualizamos os binarios de SQL Server, proceso que non afecta ás BDs xeradas, e que ademais é reversible, sendo posible facer un downgrade de RPMs sen afectar, segundo a doc de Microsoft, ás BDs:
Paramos o servizo mssql-server e actualizamos con yum:
[root@labapm ~]# systemctl stop mssql-server [root@labapm ~]# yum update mssql-server mssql-server-fts mssql-server-agent mssql-tools Loaded plugins: ulninfo Resolving Dependencies --> Running transaction check ---> Package mssql-server.x86_64 0:14.0.900.75-1 will be updated ---> Package mssql-server.x86_64 0:14.0.3015.40-1 will be an update ---> Package mssql-server-agent.x86_64 0:14.0.900.75-1 will be updated ---> Package mssql-server-agent.x86_64 0:14.0.3015.40-1 will be an update ---> Package mssql-server-fts.x86_64 0:14.0.900.75-1 will be updated ---> Package mssql-server-fts.x86_64 0:14.0.3015.40-1 will be an update --> Finished Dependency Resolution Dependencies Resolved =================================================================================================================================================================================================================== Package Arch Version Repository Size =================================================================================================================================================================================================================== Updating: mssql-server x86_64 14.0.3015.40-1 packages-microsoft-com-mssql-server-2017 166 M mssql-server-agent x86_64 14.0.3015.40-1 packages-microsoft-com-mssql-server-2017 1.5 M mssql-server-fts x86_64 14.0.3015.40-1 packages-microsoft-com-mssql-server-2017 229 M Transaction Summary =================================================================================================================================================================================================================== Upgrade 3 Packages Total download size: 396 M Is this ok [y/d/N]: y Downloading packages: Delta RPMs disabled because /usr/bin/applydeltarpm not installed. (1/3): mssql-server-agent-14.0.3015.40-1.x86_64.rpm | 1.5 MB 00:00:00 (2/3): mssql-server-14.0.3015.40-1.x86_64.rpm | 166 MB 00:00:21 (3/3): mssql-server-fts-14.0.3015.40-1.x86_64.rpm | 229 MB 00:01:00 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Total 6.5 MB/s | 396 MB 00:01:01 Running transaction check Running transaction test Transaction test succeeded Running transaction Updating : mssql-server-14.0.3015.40-1.x86_64 1/6 Updating : mssql-server-fts-14.0.3015.40-1.x86_64 2/6 +-------------------------------------------------------------------------------------+ Please restart mssql-server to enable Microsoft SQL Server Full Text Search. +-------------------------------------------------------------------------------------+ Updating : mssql-server-agent-14.0.3015.40-1.x86_64 3/6 +--------------------------------------------------------------------------------+ Please restart mssql-server to enable Microsoft SQL Server Agent. +--------------------------------------------------------------------------------+ Cleanup : mssql-server-agent-14.0.900.75-1.x86_64 4/6 Cleanup : mssql-server-fts-14.0.900.75-1.x86_64 5/6 Cleanup : mssql-server-14.0.900.75-1.x86_64 6/6 Verifying : mssql-server-fts-14.0.3015.40-1.x86_64 1/6 Verifying : mssql-server-agent-14.0.3015.40-1.x86_64 2/6 Verifying : mssql-server-14.0.3015.40-1.x86_64 3/6 Verifying : mssql-server-14.0.900.75-1.x86_64 4/6 Verifying : mssql-server-agent-14.0.900.75-1.x86_64 5/6 Verifying : mssql-server-fts-14.0.900.75-1.x86_64 6/6 Updated: mssql-server.x86_64 0:14.0.3015.40-1 mssql-server-agent.x86_64 0:14.0.3015.40-1 mssql-server-fts.x86_64 0:14.0.3015.40-1 Complete!
Actualización a licencia Developer
Para ter unha licencia gratuíta e permanente, sen limitación de uso, aplicamos un cambio de configuración. Paramos de novo o servizo mssql-server e lanzamos mssql-conf para facer o cambio de licencia.
[root@labapm ~]# systemctl stop mssql-server [root@labapm ~]# /opt/mssql/bin/mssql-conf setup Choose an edition of SQL Server: 1) Evaluation (free, no production use rights, 180-day limit) 2) Developer (free, no production use rights) 3) Express (free) 4) Web (PAID) 5) Standard (PAID) 6) Enterprise (PAID) 7) Enterprise Core (PAID) 8) I bought a license through a retail sales channel and have a product key to enter. Details about editions can be found at https://go.microsoft.com/fwlink/?LinkId=852748&clcid=0x409 Use of PAID editions of this software requires separate licensing through a Microsoft Volume Licensing program. By choosing a PAID edition, you are verifying that you have the appropriate number of licenses in place to install and run this software. Enter your edition(1-8): 2 The license terms for this product can be found in /usr/share/doc/mssql-server or downloaded from: https://go.microsoft.com/fwlink/?LinkId=855862&clcid=0x409 The privacy statement can be viewed at: https://go.microsoft.com/fwlink/?LinkId=853010&clcid=0x409 Enter the SQL Server system administrator password: Confirm the SQL Server system administrator password: Configuring SQL Server... The licensing PID was successfully processed. The new edition is [Developer Edition]. Setup has completed successfully. SQL Server is now starting.
Resultado final
Conectamos ó servidor para verificar que tanto a versión como a edición foron actualizadas:
1> :setvar SQLCMDMAXVARTYPEWIDTH 35
2> :setvar SQLCMDMAXFIXEDTYPEWIDTH 35
3> SELECT SERVERPROPERTY('productversion') as Version, SERVERPROPERTY ('productlevel') as Level ,SERVERPROPERTY ('edition') as Edition
4> go
Version Level Edition
----------------------------------- ----------------------------------- -----------------------------------
14.0.3015.40 RTM Developer Edition (64-bit)
