{"id":8854,"date":"2018-01-17T16:39:22","date_gmt":"2018-01-17T15:39:22","guid":{"rendered":"http:\/\/arumel.com\/?p=8854"},"modified":"2018-01-17T16:39:22","modified_gmt":"2018-01-17T15:39:22","slug":"upgrade-de-version-licenza-sqlserver-2017-linux","status":"publish","type":"post","link":"https:\/\/arumel.com\/eu\/upgrade-de-version-licenza-sqlserver-2017-linux\/","title":{"rendered":"Upgrade de versi\u00f3n e licenza SQLServer 2017 Linux"},"content":{"rendered":"<h1><span style=\"color: #000000;\">Versi\u00f3n e edici\u00f3n de partida no noso SQL Server 2017<br \/>\n<\/span><\/h1>\n<p>Partimos dun escenario cunha versi\u00f3n RC SQLServer, previa \u00e1 versi\u00f3n RTM, concretamente unha RC2 (Release Candidate 2). A edici\u00f3n \u00e9 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 e versi\u00f3n SQL Server 2017<\/span><\/h1>\n<p>Podemos obter informaci\u00f3n sobre a actualizaci\u00f3n de edici\u00f3ns na <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>\u00e9 posible pasar dunda Evaluation Enterprise a unha 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 canto \u00e1s versi\u00f3ns dende a que podemos facer un upgrade, nas <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/linux\/sql-server-linux-release-notes\">release notes de SQL Server 2017<\/a> ind\u00edcase que <strong>o upgrade \u00e9 viable dende versi\u00f3n CTP 2.1<\/strong>, previa \u00e1 RC2 da 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>Polo tanto, a actualizaci\u00f3n que precisamos est\u00e1 dentro do soporte de 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>Nesta instalaci\u00f3n, precisamos comezar engadindo un novo repositorio, xa que para a instalaci\u00f3n inicial foi empregado o CTP dispo\u00f1ible no momento de liberaci\u00f3n desta versi\u00f3n. Engadimos o repositorio CU (Cumulative Updates) que \u00e9 o que nos interesa fronte o GDR que s\u00f3 incl\u00fae a versi\u00f3n base e parches cr\u00edticos (aproveito para agradecer \u00f3 colega <strong>Ignacio Vizoso<\/strong> por aportarme este punto \u00f3 procedemento 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>Agora actualizamos os binarios de SQL Server, proceso que non afecta \u00e1s BDs xeradas, e que ademais \u00e9 reversible, sendo posible facer un downgrade de RPMs sen afectar, segundo a doc de Microsoft, \u00e1s 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><span style=\"font-family: Gandhi Sans;\">Paramos o servizo mssql-server e actualizamos con yum:<br \/>\n<\/span><\/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 ter unha licencia gratu\u00edta e permanente, sen limitaci\u00f3n de uso, aplicamos un cambio de configuraci\u00f3n. Paramos de novo o servizo mssql-server e lanzamos mssql-conf para facer o 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>Conectamos \u00f3 servidor para verificar que tanto a versi\u00f3n como a edici\u00f3n foron 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 e edici\u00f3n de partida no noso SQL Server 2017 Partimos dun escenario cunha versi\u00f3n RC SQLServer, previa \u00e1 versi\u00f3n RTM, concretamente unha RC2 (Release Candidate 2). A edici\u00f3n \u00e9 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, SERVERPROPERTY (&#8216;productlevel&#8217;) as Level ,SERVERPROPERTY [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":8865,"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":[41,47],"tags":[],"class_list":["post-8854","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-portada-eu","category-slider-post-eu"],"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 e licenza 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\/eu\/upgrade-de-version-licenza-sqlserver-2017-linux\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Upgrade de versi\u00f3n e licenza SQLServer 2017 Linux - Arumel\" \/>\n<meta property=\"og:description\" content=\"Versi\u00f3n e edici\u00f3n de partida no noso SQL Server 2017 Partimos dun escenario cunha versi\u00f3n RC SQLServer, previa \u00e1 versi\u00f3n RTM, concretamente unha RC2 (Release Candidate 2). A edici\u00f3n \u00e9 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, SERVERPROPERTY (&#039;productlevel&#039;) as Level ,SERVERPROPERTY [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"http:\/\/arumel.com\/eu\/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:39:22+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=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alberto Pereiro\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\\\/\\\/arumel.com\\\/eu\\\/upgrade-de-version-licenza-sqlserver-2017-linux\\\/#article\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/eu\\\/upgrade-de-version-licenza-sqlserver-2017-linux\\\/\"},\"author\":{\"name\":\"Alberto Pereiro\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/1cdc5947f4270801792b02ec92332edc\"},\"headline\":\"Upgrade de versi\u00f3n e licenza SQLServer 2017 Linux\",\"datePublished\":\"2018-01-17T15:39:22+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/eu\\\/upgrade-de-version-licenza-sqlserver-2017-linux\\\/\"},\"wordCount\":304,\"commentCount\":0,\"image\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/eu\\\/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\"],\"inLanguage\":\"eu\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\\\/\\\/arumel.com\\\/eu\\\/upgrade-de-version-licenza-sqlserver-2017-linux\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\\\/\\\/arumel.com\\\/eu\\\/upgrade-de-version-licenza-sqlserver-2017-linux\\\/\",\"url\":\"http:\\\/\\\/arumel.com\\\/eu\\\/upgrade-de-version-licenza-sqlserver-2017-linux\\\/\",\"name\":\"Upgrade de versi\u00f3n e licenza SQLServer 2017 Linux - Arumel\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/eu\\\/upgrade-de-version-licenza-sqlserver-2017-linux\\\/#primaryimage\"},\"image\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/eu\\\/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:39:22+00:00\",\"author\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/1cdc5947f4270801792b02ec92332edc\"},\"breadcrumb\":{\"@id\":\"http:\\\/\\\/arumel.com\\\/eu\\\/upgrade-de-version-licenza-sqlserver-2017-linux\\\/#breadcrumb\"},\"inLanguage\":\"eu\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\\\/\\\/arumel.com\\\/eu\\\/upgrade-de-version-licenza-sqlserver-2017-linux\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"eu\",\"@id\":\"http:\\\/\\\/arumel.com\\\/eu\\\/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\\\/eu\\\/upgrade-de-version-licenza-sqlserver-2017-linux\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Portada\",\"item\":\"http:\\\/\\\/arumel.com\\\/eu\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Upgrade de versi\u00f3n e licenza 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\":\"eu\"},{\"@type\":\"Person\",\"@id\":\"http:\\\/\\\/arumel.com\\\/#\\\/schema\\\/person\\\/1cdc5947f4270801792b02ec92332edc\",\"name\":\"Alberto Pereiro\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"eu\",\"@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\\\/eu\\\/author\\\/alberto\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Upgrade de versi\u00f3n e licenza 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\/eu\/upgrade-de-version-licenza-sqlserver-2017-linux\/","og_locale":"en_US","og_type":"article","og_title":"Upgrade de versi\u00f3n e licenza SQLServer 2017 Linux - Arumel","og_description":"Versi\u00f3n e edici\u00f3n de partida no noso SQL Server 2017 Partimos dun escenario cunha versi\u00f3n RC SQLServer, previa \u00e1 versi\u00f3n RTM, concretamente unha RC2 (Release Candidate 2). A edici\u00f3n \u00e9 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, SERVERPROPERTY ('productlevel') as Level ,SERVERPROPERTY [&hellip;]","og_url":"http:\/\/arumel.com\/eu\/upgrade-de-version-licenza-sqlserver-2017-linux\/","og_site_name":"Arumel","article_published_time":"2018-01-17T15:39:22+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":{"Written by":"Alberto Pereiro","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/arumel.com\/eu\/upgrade-de-version-licenza-sqlserver-2017-linux\/#article","isPartOf":{"@id":"http:\/\/arumel.com\/eu\/upgrade-de-version-licenza-sqlserver-2017-linux\/"},"author":{"name":"Alberto Pereiro","@id":"http:\/\/arumel.com\/#\/schema\/person\/1cdc5947f4270801792b02ec92332edc"},"headline":"Upgrade de versi\u00f3n e licenza SQLServer 2017 Linux","datePublished":"2018-01-17T15:39:22+00:00","mainEntityOfPage":{"@id":"http:\/\/arumel.com\/eu\/upgrade-de-version-licenza-sqlserver-2017-linux\/"},"wordCount":304,"commentCount":0,"image":{"@id":"http:\/\/arumel.com\/eu\/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"],"inLanguage":"eu","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/arumel.com\/eu\/upgrade-de-version-licenza-sqlserver-2017-linux\/#respond"]}]},{"@type":"WebPage","@id":"http:\/\/arumel.com\/eu\/upgrade-de-version-licenza-sqlserver-2017-linux\/","url":"http:\/\/arumel.com\/eu\/upgrade-de-version-licenza-sqlserver-2017-linux\/","name":"Upgrade de versi\u00f3n e licenza SQLServer 2017 Linux - Arumel","isPartOf":{"@id":"http:\/\/arumel.com\/#website"},"primaryImageOfPage":{"@id":"http:\/\/arumel.com\/eu\/upgrade-de-version-licenza-sqlserver-2017-linux\/#primaryimage"},"image":{"@id":"http:\/\/arumel.com\/eu\/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:39:22+00:00","author":{"@id":"http:\/\/arumel.com\/#\/schema\/person\/1cdc5947f4270801792b02ec92332edc"},"breadcrumb":{"@id":"http:\/\/arumel.com\/eu\/upgrade-de-version-licenza-sqlserver-2017-linux\/#breadcrumb"},"inLanguage":"eu","potentialAction":[{"@type":"ReadAction","target":["http:\/\/arumel.com\/eu\/upgrade-de-version-licenza-sqlserver-2017-linux\/"]}]},{"@type":"ImageObject","inLanguage":"eu","@id":"http:\/\/arumel.com\/eu\/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\/eu\/upgrade-de-version-licenza-sqlserver-2017-linux\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Portada","item":"http:\/\/arumel.com\/eu\/"},{"@type":"ListItem","position":2,"name":"Upgrade de versi\u00f3n e licenza 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":"eu"},{"@type":"Person","@id":"http:\/\/arumel.com\/#\/schema\/person\/1cdc5947f4270801792b02ec92332edc","name":"Alberto Pereiro","image":{"@type":"ImageObject","inLanguage":"eu","@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\/eu\/author\/alberto\/"}]}},"jetpack_publicize_connections":[],"jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9uvW6-2iO","jetpack_likes_enabled":true,"jetpack-related-posts":[{"id":8796,"url":"https:\/\/arumel.com\/upgrade-de-version-licenza-sqlserver-2017-linux\/","url_meta":{"origin":8854,"position":0},"title":"Upgrade de versi\u00f3n e licenza SQLServer 2017 Linux","author":"Alberto Pereiro","date":"17 January, 2018","format":false,"excerpt":"","rel":"","context":"In &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":8857,"url":"https:\/\/arumel.com\/es\/upgrade-de-version-y-licencia-sqlserver-2017-linux\/","url_meta":{"origin":8854,"position":1},"title":"Upgrade de versi\u00f3n y licencia SQLServer 2017 Linux","author":"Alberto Pereiro","date":"17 January, 2018","format":false,"excerpt":"","rel":"","context":"In &quot;portada&quot;","block_context":{"text":"portada","link":"https:\/\/arumel.com\/es\/portada-es\/"},"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":8860,"url":"https:\/\/arumel.com\/ca\/upgrade-de-version-y-licencia-sqlserver-2017-linux\/","url_meta":{"origin":8854,"position":2},"title":"Upgrade de versi\u00f3n y licencia SQLServer 2017 Linux","author":"Alberto Pereiro","date":"17 January, 2018","format":false,"excerpt":"","rel":"","context":"In &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":8862,"url":"https:\/\/arumel.com\/en\/sql-server-2017-version-and-license-upgrade-on-linux\/","url_meta":{"origin":8854,"position":3},"title":"SQL Server 2017 version and license upgrade on Linux","author":"Alberto Pereiro","date":"17 January, 2018","format":false,"excerpt":"","rel":"","context":"In &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":7890,"url":"https:\/\/arumel.com\/stored-outlines-en-standard-edition\/","url_meta":{"origin":8854,"position":4},"title":"Stored Outlines en Standard Edition","author":"Alberto Pereiro","date":"12 July, 2017","format":false,"excerpt":"","rel":"","context":"In &quot;Oracle&quot;","block_context":{"text":"Oracle","link":"https:\/\/arumel.com\/oracle-2\/"},"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":7898,"url":"https:\/\/arumel.com\/eu\/stored-outlines-en-standard-edition\/","url_meta":{"origin":8854,"position":5},"title":"Stored Outlines en Standard Edition","author":"Alberto Pereiro","date":"12 July, 2017","format":false,"excerpt":"","rel":"","context":"In &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":[]}],"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\/eu\/wp-json\/wp\/v2\/posts\/8854","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/arumel.com\/eu\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/arumel.com\/eu\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/arumel.com\/eu\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/arumel.com\/eu\/wp-json\/wp\/v2\/comments?post=8854"}],"version-history":[{"count":1,"href":"https:\/\/arumel.com\/eu\/wp-json\/wp\/v2\/posts\/8854\/revisions"}],"predecessor-version":[{"id":8855,"href":"https:\/\/arumel.com\/eu\/wp-json\/wp\/v2\/posts\/8854\/revisions\/8855"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/arumel.com\/eu\/wp-json\/wp\/v2\/media\/8865"}],"wp:attachment":[{"href":"https:\/\/arumel.com\/eu\/wp-json\/wp\/v2\/media?parent=8854"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/arumel.com\/eu\/wp-json\/wp\/v2\/categories?post=8854"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/arumel.com\/eu\/wp-json\/wp\/v2\/tags?post=8854"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}