{"id":8857,"date":"2018-01-17T16:40:57","date_gmt":"2018-01-17T15:40:57","guid":{"rendered":"http:\/\/arumel.com\/?p=8857"},"modified":"2018-02-22T19:35:24","modified_gmt":"2018-02-22T18:35:24","slug":"upgrade-de-version-y-licencia-sqlserver-2017-linux","status":"publish","type":"post","link":"https:\/\/arumel.com\/es\/upgrade-de-version-y-licencia-sqlserver-2017-linux\/","title":{"rendered":"Upgrade de versi\u00f3n y licencia SQLServer 2017 Linux"},"content":{"rendered":"<h1><span style=\"color: #000000;\">Versi\u00f3n y edici\u00f3n de partida en nuestro SQL Server 2017<br \/>\n<\/span><\/h1>\n<p>Partimos de un escenario con una versi\u00f3n RC de SQL Server, previa a la versi\u00f3n RTM, concretamente una RC2 (Release Candidate 2). La edici\u00f3n es Enterprise Evaluation, con limitaci\u00f3n temporal de uso.<\/p>\n<pre class=\"theme:terminal lang:default decode:true\">1&gt; :setvar SQLCMDMAXVARTYPEWIDTH 35\r\n2&gt; :setvar SQLCMDMAXFIXEDTYPEWIDTH 35\r\n3&gt; SELECT SERVERPROPERTY('productversion') as Version, SERVERPROPERTY ('productlevel') as Level ,SERVERPROPERTY ('edition') as Edition\r\n4&gt; go\r\nVersion Level Edition \r\n----------------------------------- ----------------------------------- -----------------------------------\r\n14.0.900.75 RC2 Enterprise Evaluation Edition (64-b<\/pre>\n<h1><span style=\"color: #000000;\">Posibilidades de upgrade de edici\u00f3n y versi\u00f3n SQL Server 2017<\/span><\/h1>\n<p>Podemos obtener informaci\u00f3n sobre la actualizaci\u00f3n de ediciones en la <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/install-windows\/supported-version-and-edition-upgrades-2017\">web de Microsoft<\/a>. Comprobamos que <strong>es posible pasar de una Evaluation Enterprise a una Developer<\/strong>.<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-8797 size-large\" src=\"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/Selecci%C3%B3n_332-1024x445.png?resize=1024%2C445\" alt=\"\" width=\"1024\" height=\"445\" srcset=\"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/Selecci%C3%B3n_332.png?resize=1024%2C445&amp;ssl=1 1024w, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/Selecci%C3%B3n_332.png?resize=300%2C130&amp;ssl=1 300w, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/Selecci%C3%B3n_332.png?resize=768%2C334&amp;ssl=1 768w, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/Selecci%C3%B3n_332.png?resize=610%2C265&amp;ssl=1 610w, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/Selecci%C3%B3n_332.png?w=1056&amp;ssl=1 1056w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<p>En cuanto a las versiones desde las que podemos hacer un upgrtade, en las <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/linux\/sql-server-linux-release-notes\">release notes de SQL Server 2017<\/a> se indica que <strong>el upgrade es viable desde la versi\u00f3n CTP 2.1<\/strong>, previa a la RC2 de la que partimos.<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-8832 size-full\" src=\"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/Selecci%C3%B3n_344.png?resize=681%2C73\" alt=\"\" width=\"681\" height=\"73\" srcset=\"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/Selecci%C3%B3n_344.png?w=681&amp;ssl=1 681w, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/Selecci%C3%B3n_344.png?resize=300%2C32&amp;ssl=1 300w, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/Selecci%C3%B3n_344.png?resize=610%2C65&amp;ssl=1 610w\" sizes=\"(max-width: 681px) 100vw, 681px\" \/><\/p>\n<p>Por lo tanto, la actualizaci\u00f3n que necesitamos est\u00e1 dentro de soporte Microsoft.<\/p>\n<h1><span style=\"color: #000000;\">Actualizaci\u00f3n de RC2 (14.0.900.75) a RTM CU3 (14.0.3015.40)<\/span><\/h1>\n<p>En esta instalaci\u00f3n, necesitamos empezar a\u00f1adiendo un repositorio, ya que para la instalaci\u00f3n inicial fue utilizado el CTP disponible en el momento de liberaci\u00f3n de esa versi\u00f3n. A\u00f1adimos el repositorio CU (Cumulative Updates) que es el que nos interesa frente al GDR que solo incluye la versi\u00f3n base y parches cr\u00edticos (aprovecho para agradecer al colega <strong>Ignacio Vizoso<\/strong> por aportarme este punto al procedimiento de upgrade).<\/p>\n<pre class=\"theme:terminal lang:default decode:true\">sudo curl -o \/etc\/yum.repos.d\/mssql-server.repo https:\/\/packages.microsoft.com\/config\/rhel\/7\/mssql-server-2017.repo<\/pre>\n<p>Ahora actualizamos los binarios de SQL Server, proceso que no afecta a las BDs generadas, y que adem\u00e1s es reversible, siendo posible hacer un downgrade de RPMs sin afectar, seg\u00fan la doc de Microsoft, a las BDs:<\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-8824 size-full\" src=\"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/Selecci%C3%B3n_343.png?resize=1023%2C66\" alt=\"\" width=\"1023\" height=\"66\" srcset=\"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/Selecci%C3%B3n_343.png?w=1023&amp;ssl=1 1023w, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/Selecci%C3%B3n_343.png?resize=300%2C19&amp;ssl=1 300w, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/Selecci%C3%B3n_343.png?resize=768%2C50&amp;ssl=1 768w, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/Selecci%C3%B3n_343.png?resize=610%2C39&amp;ssl=1 610w\" sizes=\"(max-width: 1023px) 100vw, 1023px\" \/><\/p>\n<p><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" class=\"wp-image-8840 size-full aligncenter\" src=\"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/Selecci%C3%B3n_345.png?resize=733%2C62\" alt=\"\" width=\"733\" height=\"62\" srcset=\"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/Selecci%C3%B3n_345.png?w=733&amp;ssl=1 733w, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/Selecci%C3%B3n_345.png?resize=300%2C25&amp;ssl=1 300w, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/Selecci%C3%B3n_345.png?resize=610%2C52&amp;ssl=1 610w\" sizes=\"(max-width: 733px) 100vw, 733px\" \/><\/p>\n<p>Paramos el servicio mssql-server y actualizamos con yum<\/p>\n<pre class=\"theme:terminal lang:default decode:true \">[root@labapm ~]# systemctl stop mssql-server\r\n[root@labapm ~]# yum update mssql-server mssql-server-fts mssql-server-agent mssql-tools\r\nLoaded plugins: ulninfo\r\nResolving Dependencies\r\n--&gt; Running transaction check\r\n---&gt; Package mssql-server.x86_64 0:14.0.900.75-1 will be updated\r\n---&gt; Package mssql-server.x86_64 0:14.0.3015.40-1 will be an update\r\n---&gt; Package mssql-server-agent.x86_64 0:14.0.900.75-1 will be updated\r\n---&gt; Package mssql-server-agent.x86_64 0:14.0.3015.40-1 will be an update\r\n---&gt; Package mssql-server-fts.x86_64 0:14.0.900.75-1 will be updated\r\n---&gt; Package mssql-server-fts.x86_64 0:14.0.3015.40-1 will be an update\r\n--&gt; Finished Dependency Resolution\r\n\r\nDependencies Resolved\r\n\r\n===================================================================================================================================================================================================================\r\n Package                                          Arch                                 Version                                        Repository                                                              Size\r\n===================================================================================================================================================================================================================\r\nUpdating:\r\n mssql-server                                     x86_64                               14.0.3015.40-1                                 packages-microsoft-com-mssql-server-2017                               166 M\r\n mssql-server-agent                               x86_64                               14.0.3015.40-1                                 packages-microsoft-com-mssql-server-2017                               1.5 M\r\n mssql-server-fts                                 x86_64                               14.0.3015.40-1                                 packages-microsoft-com-mssql-server-2017                               229 M\r\n\r\nTransaction Summary\r\n===================================================================================================================================================================================================================\r\nUpgrade  3 Packages\r\n\r\nTotal download size: 396 M\r\nIs this ok [y\/d\/N]: y\r\nDownloading packages:\r\nDelta RPMs disabled because \/usr\/bin\/applydeltarpm not installed.\r\n(1\/3): mssql-server-agent-14.0.3015.40-1.x86_64.rpm                                                                                                                                         | 1.5 MB  00:00:00     \r\n(2\/3): mssql-server-14.0.3015.40-1.x86_64.rpm                                                                                                                                               | 166 MB  00:00:21     \r\n(3\/3): mssql-server-fts-14.0.3015.40-1.x86_64.rpm                                                                                                                                           | 229 MB  00:01:00     \r\n-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------\r\nTotal                                                                                                                                                                              6.5 MB\/s | 396 MB  00:01:01     \r\nRunning transaction check\r\nRunning transaction test\r\nTransaction test succeeded\r\nRunning transaction\r\n  Updating   : mssql-server-14.0.3015.40-1.x86_64                                                                                                                                                              1\/6 \r\n  Updating   : mssql-server-fts-14.0.3015.40-1.x86_64                                                                                                                                                          2\/6 \r\n\r\n+-------------------------------------------------------------------------------------+\r\nPlease restart mssql-server to enable Microsoft SQL Server Full Text Search.\r\n+-------------------------------------------------------------------------------------+\r\n\r\n  Updating   : mssql-server-agent-14.0.3015.40-1.x86_64                                                                                                                                                        3\/6 \r\n\r\n+--------------------------------------------------------------------------------+\r\nPlease restart mssql-server to enable Microsoft SQL Server Agent.\r\n+--------------------------------------------------------------------------------+\r\n\r\n  Cleanup    : mssql-server-agent-14.0.900.75-1.x86_64                                                                                                                                                         4\/6 \r\n  Cleanup    : mssql-server-fts-14.0.900.75-1.x86_64                                                                                                                                                           5\/6 \r\n  Cleanup    : mssql-server-14.0.900.75-1.x86_64                                                                                                                                                               6\/6 \r\n  Verifying  : mssql-server-fts-14.0.3015.40-1.x86_64                                                                                                                                                          1\/6 \r\n  Verifying  : mssql-server-agent-14.0.3015.40-1.x86_64                                                                                                                                                        2\/6 \r\n  Verifying  : mssql-server-14.0.3015.40-1.x86_64                                                                                                                                                              3\/6 \r\n  Verifying  : mssql-server-14.0.900.75-1.x86_64                                                                                                                                                               4\/6 \r\n  Verifying  : mssql-server-agent-14.0.900.75-1.x86_64                                                                                                                                                         5\/6 \r\n  Verifying  : mssql-server-fts-14.0.900.75-1.x86_64                                                                                                                                                           6\/6 \r\n\r\nUpdated:\r\n  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                             \r\n\r\nComplete!<\/pre>\n<h1><span style=\"color: #000000;\">Actualizaci\u00f3n a licencia Developer<\/span><\/h1>\n<p>Para disponer de una licencia gratu\u00edta y permanente, sin limitaci\u00f3n de uso, aplicamos un cambio de configuraci\u00f3n. Paramos el nuevo servicio mssql-server y lanzamos mssql-conf para aplicar el cambio de licencia.<\/p>\n<pre class=\"theme:terminal lang:default decode:true \">[root@labapm ~]# systemctl stop mssql-server\r\n[root@labapm ~]# \/opt\/mssql\/bin\/mssql-conf setup\r\nChoose an edition of SQL Server:\r\n  1) Evaluation (free, no production use rights, 180-day limit)\r\n  2) Developer (free, no production use rights)\r\n  3) Express (free)\r\n  4) Web (PAID)\r\n  5) Standard (PAID)\r\n  6) Enterprise (PAID)\r\n  7) Enterprise Core (PAID)\r\n  8) I bought a license through a retail sales channel and have a product key to enter.\r\n\r\nDetails about editions can be found at\r\nhttps:\/\/go.microsoft.com\/fwlink\/?LinkId=852748&clcid=0x409\r\n\r\nUse of PAID editions of this software requires separate licensing through a\r\nMicrosoft Volume Licensing program.\r\nBy choosing a PAID edition, you are verifying that you have the appropriate\r\nnumber of licenses in place to install and run this software.\r\n\r\nEnter your edition(1-8): 2\r\nThe license terms for this product can be found in\r\n\/usr\/share\/doc\/mssql-server or downloaded from:\r\nhttps:\/\/go.microsoft.com\/fwlink\/?LinkId=855862&clcid=0x409\r\n\r\nThe privacy statement can be viewed at:\r\nhttps:\/\/go.microsoft.com\/fwlink\/?LinkId=853010&clcid=0x409\r\n\r\nEnter the SQL Server system administrator password: \r\nConfirm the SQL Server system administrator password: \r\nConfiguring SQL Server...\r\n\r\nThe licensing PID was successfully processed. The new edition is [Developer Edition].\r\nSetup has completed successfully. SQL Server is now starting.\r\n<\/pre>\n<h1><span style=\"color: #000000;\">Resultado final<\/span><\/h1>\n<p>Nos conectamos al servidor para verificar que tanto la versi\u00f3n como la edici\u00f3n han sido actualizadas:<\/p>\n<pre class=\"theme:terminal lang:default decode:true \">1&gt; :setvar SQLCMDMAXVARTYPEWIDTH 35\r\n2&gt; :setvar SQLCMDMAXFIXEDTYPEWIDTH 35\r\n3&gt; SELECT SERVERPROPERTY('productversion') as Version, SERVERPROPERTY ('productlevel') as Level ,SERVERPROPERTY ('edition') as Edition\r\n4&gt; go\r\nVersion                             Level                               Edition                            \r\n----------------------------------- ----------------------------------- -----------------------------------\r\n14.0.3015.40                        RTM                                 Developer Edition (64-bit)<\/pre>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Versi\u00f3n y edici\u00f3n de partida en nuestro SQL Server 2017 Partimos de un escenario con una versi\u00f3n RC de SQL Server, previa a la versi\u00f3n RTM, concretamente una RC2 (Release Candidate 2). La edici\u00f3n es Enterprise Evaluation, con limitaci\u00f3n temporal de uso. 1&gt; :setvar SQLCMDMAXVARTYPEWIDTH 35 2&gt; :setvar SQLCMDMAXFIXEDTYPEWIDTH 35 3&gt; SELECT SERVERPROPERTY(&#8216;productversion&#8217;) as Version, [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":8868,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false},"categories":[27,50,63],"tags":[],"class_list":["post-8857","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-portada-es","category-slider-post-es","category-sqlserver-es"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Upgrade de versi\u00f3n y licencia SQLServer 2017 Linux - Arumel<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/arumel.com\/upgrade-de-version-licenza-sqlserver-2017-linux\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Upgrade de versi\u00f3n y licencia SQLServer 2017 Linux - Arumel\" \/>\n<meta property=\"og:description\" content=\"Versi\u00f3n y edici\u00f3n de partida en nuestro SQL Server 2017 Partimos de un escenario con una versi\u00f3n RC de SQL Server, previa a la versi\u00f3n RTM, concretamente una RC2 (Release Candidate 2). La edici\u00f3n es Enterprise Evaluation, con limitaci\u00f3n temporal de uso. 1&gt; :setvar SQLCMDMAXVARTYPEWIDTH 35 2&gt; :setvar SQLCMDMAXFIXEDTYPEWIDTH 35 3&gt; SELECT SERVERPROPERTY(&#039;productversion&#039;) as Version, [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"http:\/\/arumel.com\/upgrade-de-version-licenza-sqlserver-2017-linux\/\" \/>\n<meta property=\"og:site_name\" content=\"Arumel\" \/>\n<meta property=\"article:published_time\" content=\"2018-01-17T15:40:57+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2018-02-22T18:35:24+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vera_alberto_contraste.jpg?fit=2340%2C4160\" \/>\n\t<meta property=\"og:image:width\" content=\"2340\" \/>\n\t<meta property=\"og:image:height\" content=\"4160\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Alberto Pereiro\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alberto Pereiro\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/arumel.com\\\/upgrade-de-version-licenza-sqlserver-2017-linux\\\/#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/upgrade-de-version-licenza-sqlserver-2017-linux\\\/\"},\"author\":{\"name\":\"Alberto Pereiro\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/1cdc5947f4270801792b02ec92332edc\"},\"headline\":\"Upgrade de versi\u00f3n y licencia SQLServer 2017 Linux\",\"datePublished\":\"2018-01-17T15:40:57+00:00\",\"dateModified\":\"2018-02-22T18:35:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/upgrade-de-version-licenza-sqlserver-2017-linux\\\/\"},\"wordCount\":332,\"commentCount\":0,\"image\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/upgrade-de-version-licenza-sqlserver-2017-linux\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/vera_alberto_contraste.jpg?fit=2340%2C4160&ssl=1\",\"articleSection\":[\"portada\",\"slider-post\",\"SQL Server\"],\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\\\/\\\/arumel.com\\\/upgrade-de-version-licenza-sqlserver-2017-linux\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/arumel.com\\\/upgrade-de-version-licenza-sqlserver-2017-linux\\\/\",\"url\":\"http:\\\/\\\/arumel.com\\\/upgrade-de-version-licenza-sqlserver-2017-linux\\\/\",\"name\":\"Upgrade de versi\u00f3n y licencia SQLServer 2017 Linux - Arumel\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/upgrade-de-version-licenza-sqlserver-2017-linux\\\/#primaryimage\"},\"image\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/upgrade-de-version-licenza-sqlserver-2017-linux\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/vera_alberto_contraste.jpg?fit=2340%2C4160&ssl=1\",\"datePublished\":\"2018-01-17T15:40:57+00:00\",\"dateModified\":\"2018-02-22T18:35:24+00:00\",\"author\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/1cdc5947f4270801792b02ec92332edc\"},\"breadcrumb\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/upgrade-de-version-licenza-sqlserver-2017-linux\\\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/arumel.com\\\/upgrade-de-version-licenza-sqlserver-2017-linux\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"http:\\\/\\\/arumel.com\\\/upgrade-de-version-licenza-sqlserver-2017-linux\\\/#primaryimage\",\"url\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/vera_alberto_contraste.jpg?fit=2340%2C4160&ssl=1\",\"contentUrl\":\"https:\\\/\\\/i0.wp.com\\\/arumel.com\\\/wp-content\\\/uploads\\\/2018\\\/01\\\/vera_alberto_contraste.jpg?fit=2340%2C4160&ssl=1\",\"width\":2340,\"height\":4160},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\\\/\\\/arumel.com\\\/upgrade-de-version-licenza-sqlserver-2017-linux\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"https:\\\/\\\/arumel.com\\\/es\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Upgrade de versi\u00f3n y licencia SQLServer 2017 Linux\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#website\",\"url\":\"http:\\\/\\\/arumel.com\\\/\",\"name\":\"Arumel\",\"description\":\"Outro sitio WordPress m\u00e1is\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\\\/\\\/arumel.com\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/1cdc5947f4270801792b02ec92332edc\",\"name\":\"Alberto Pereiro\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a375a0c812714ad00388e6453d01b2231aa1ebc4e50587c1cf7eeee09e04eb64?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a375a0c812714ad00388e6453d01b2231aa1ebc4e50587c1cf7eeee09e04eb64?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/a375a0c812714ad00388e6453d01b2231aa1ebc4e50587c1cf7eeee09e04eb64?s=96&d=mm&r=g\",\"caption\":\"Alberto Pereiro\"},\"url\":\"https:\\\/\\\/arumel.com\\\/es\\\/author\\\/alberto\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Upgrade de versi\u00f3n y licencia SQLServer 2017 Linux - Arumel","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/arumel.com\/upgrade-de-version-licenza-sqlserver-2017-linux\/","og_locale":"es_ES","og_type":"article","og_title":"Upgrade de versi\u00f3n y licencia SQLServer 2017 Linux - Arumel","og_description":"Versi\u00f3n y edici\u00f3n de partida en nuestro SQL Server 2017 Partimos de un escenario con una versi\u00f3n RC de SQL Server, previa a la versi\u00f3n RTM, concretamente una RC2 (Release Candidate 2). La edici\u00f3n es Enterprise Evaluation, con limitaci\u00f3n temporal de uso. 1&gt; :setvar SQLCMDMAXVARTYPEWIDTH 35 2&gt; :setvar SQLCMDMAXFIXEDTYPEWIDTH 35 3&gt; SELECT SERVERPROPERTY('productversion') as Version, [&hellip;]","og_url":"http:\/\/arumel.com\/upgrade-de-version-licenza-sqlserver-2017-linux\/","og_site_name":"Arumel","article_published_time":"2018-01-17T15:40:57+00:00","article_modified_time":"2018-02-22T18:35:24+00:00","og_image":[{"width":2340,"height":4160,"url":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vera_alberto_contraste.jpg?fit=2340%2C4160","type":"image\/jpeg"}],"author":"Alberto Pereiro","twitter_card":"summary_large_image","twitter_misc":{"Escrito por":"Alberto Pereiro","Tiempo de lectura":"4 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/arumel.com\/upgrade-de-version-licenza-sqlserver-2017-linux\/#article","isPartOf":{"@id":"http:\/\/arumel.com\/upgrade-de-version-licenza-sqlserver-2017-linux\/"},"author":{"name":"Alberto Pereiro","@id":"http:\/\/arumel.com\/#\/schema\/person\/1cdc5947f4270801792b02ec92332edc"},"headline":"Upgrade de versi\u00f3n y licencia SQLServer 2017 Linux","datePublished":"2018-01-17T15:40:57+00:00","dateModified":"2018-02-22T18:35:24+00:00","mainEntityOfPage":{"@id":"http:\/\/arumel.com\/upgrade-de-version-licenza-sqlserver-2017-linux\/"},"wordCount":332,"commentCount":0,"image":{"@id":"http:\/\/arumel.com\/upgrade-de-version-licenza-sqlserver-2017-linux\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vera_alberto_contraste.jpg?fit=2340%2C4160&ssl=1","articleSection":["portada","slider-post","SQL Server"],"inLanguage":"es","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/arumel.com\/upgrade-de-version-licenza-sqlserver-2017-linux\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/arumel.com\/upgrade-de-version-licenza-sqlserver-2017-linux\/","url":"http:\/\/arumel.com\/upgrade-de-version-licenza-sqlserver-2017-linux\/","name":"Upgrade de versi\u00f3n y licencia SQLServer 2017 Linux - Arumel","isPartOf":{"@id":"http:\/\/arumel.com\/#website"},"primaryImageOfPage":{"@id":"http:\/\/arumel.com\/upgrade-de-version-licenza-sqlserver-2017-linux\/#primaryimage"},"image":{"@id":"http:\/\/arumel.com\/upgrade-de-version-licenza-sqlserver-2017-linux\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vera_alberto_contraste.jpg?fit=2340%2C4160&ssl=1","datePublished":"2018-01-17T15:40:57+00:00","dateModified":"2018-02-22T18:35:24+00:00","author":{"@id":"http:\/\/arumel.com\/#\/schema\/person\/1cdc5947f4270801792b02ec92332edc"},"breadcrumb":{"@id":"http:\/\/arumel.com\/upgrade-de-version-licenza-sqlserver-2017-linux\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["http:\/\/arumel.com\/upgrade-de-version-licenza-sqlserver-2017-linux\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"http:\/\/arumel.com\/upgrade-de-version-licenza-sqlserver-2017-linux\/#primaryimage","url":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vera_alberto_contraste.jpg?fit=2340%2C4160&ssl=1","contentUrl":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vera_alberto_contraste.jpg?fit=2340%2C4160&ssl=1","width":2340,"height":4160},{"@type":"BreadcrumbList","@id":"http:\/\/arumel.com\/upgrade-de-version-licenza-sqlserver-2017-linux\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"https:\/\/arumel.com\/es\/"},{"@type":"ListItem","position":2,"name":"Upgrade de versi\u00f3n y licencia SQLServer 2017 Linux"}]},{"@type":"WebSite","@id":"http:\/\/arumel.com\/#website","url":"http:\/\/arumel.com\/","name":"Arumel","description":"Outro sitio WordPress m\u00e1is","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/arumel.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"http:\/\/arumel.com\/#\/schema\/person\/1cdc5947f4270801792b02ec92332edc","name":"Alberto Pereiro","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/secure.gravatar.com\/avatar\/a375a0c812714ad00388e6453d01b2231aa1ebc4e50587c1cf7eeee09e04eb64?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/a375a0c812714ad00388e6453d01b2231aa1ebc4e50587c1cf7eeee09e04eb64?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/a375a0c812714ad00388e6453d01b2231aa1ebc4e50587c1cf7eeee09e04eb64?s=96&d=mm&r=g","caption":"Alberto Pereiro"},"url":"https:\/\/arumel.com\/es\/author\/alberto\/"}]}},"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9uvW6-2iR","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":8860,"url":"https:\/\/arumel.com\/ca\/upgrade-de-version-y-licencia-sqlserver-2017-linux\/","url_meta":{"origin":8857,"position":0},"title":"Upgrade de versi\u00f3n y licencia SQLServer 2017 Linux","author":"Alberto Pereiro","date":"17 de enero de 2018","format":false,"excerpt":"","rel":"","context":"En &quot;portada&quot;","block_context":{"text":"portada","link":"https:\/\/arumel.com\/ca\/portada-ca\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vera_alberto_contraste.jpg?fit=675%2C1200&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vera_alberto_contraste.jpg?fit=675%2C1200&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vera_alberto_contraste.jpg?fit=675%2C1200&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":8796,"url":"https:\/\/arumel.com\/upgrade-de-version-licenza-sqlserver-2017-linux\/","url_meta":{"origin":8857,"position":1},"title":"Upgrade de versi\u00f3n e licenza SQLServer 2017 Linux","author":"Alberto Pereiro","date":"17 de enero de 2018","format":false,"excerpt":"","rel":"","context":"En &quot;portada&quot;","block_context":{"text":"portada","link":"https:\/\/arumel.com\/portada\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vera_alberto_contraste.jpg?fit=675%2C1200&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vera_alberto_contraste.jpg?fit=675%2C1200&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vera_alberto_contraste.jpg?fit=675%2C1200&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":8854,"url":"https:\/\/arumel.com\/eu\/upgrade-de-version-licenza-sqlserver-2017-linux\/","url_meta":{"origin":8857,"position":2},"title":"Upgrade de versi\u00f3n e licenza SQLServer 2017 Linux","author":"Alberto Pereiro","date":"17 de enero de 2018","format":false,"excerpt":"","rel":"","context":"En &quot;portada&quot;","block_context":{"text":"portada","link":"https:\/\/arumel.com\/eu\/portada-eu\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vera_alberto_contraste.jpg?fit=675%2C1200&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vera_alberto_contraste.jpg?fit=675%2C1200&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vera_alberto_contraste.jpg?fit=675%2C1200&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":8862,"url":"https:\/\/arumel.com\/en\/sql-server-2017-version-and-license-upgrade-on-linux\/","url_meta":{"origin":8857,"position":3},"title":"SQL Server 2017 version and license upgrade on Linux","author":"Alberto Pereiro","date":"17 de enero de 2018","format":false,"excerpt":"","rel":"","context":"En &quot;portada&quot;","block_context":{"text":"portada","link":"https:\/\/arumel.com\/en\/portada-en\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vera_alberto_contraste.jpg?fit=675%2C1200&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vera_alberto_contraste.jpg?fit=675%2C1200&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vera_alberto_contraste.jpg?fit=675%2C1200&ssl=1&resize=525%2C300 1.5x"},"classes":[]},{"id":7898,"url":"https:\/\/arumel.com\/eu\/stored-outlines-en-standard-edition\/","url_meta":{"origin":8857,"position":4},"title":"Stored Outlines en Standard Edition","author":"Alberto Pereiro","date":"12 de julio de 2017","format":false,"excerpt":"","rel":"","context":"En &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/eu\/oracle-eu\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":7899,"url":"https:\/\/arumel.com\/ca\/stored-outlines-en-standard-edition\/","url_meta":{"origin":8857,"position":5},"title":"Stored Outlines en Standard Edition","author":"Alberto Pereiro","date":"12 de julio de 2017","format":false,"excerpt":"","rel":"","context":"En &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/ca\/oracle-ca\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2017\/07\/IMX0083.jpg?fit=1200%2C795&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/arumel.com\/wp-content\/uploads\/2018\/01\/vera_alberto_contraste.jpg?fit=2340%2C4160&ssl=1","_links":{"self":[{"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/posts\/8857","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/comments?post=8857"}],"version-history":[{"count":4,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/posts\/8857\/revisions"}],"predecessor-version":[{"id":8943,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/posts\/8857\/revisions\/8943"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/media\/8868"}],"wp:attachment":[{"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/media?parent=8857"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/categories?post=8857"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/arumel.com\/es\/wp-json\/wp\/v2\/tags?post=8857"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}