{"id":1667,"date":"2018-11-26T14:57:48","date_gmt":"2018-11-26T15:27:48","guid":{"rendered":"https:\/\/ultering.com\/it4us\/?p=1667"},"modified":"2020-03-19T23:02:56","modified_gmt":"2020-03-19T23:32:56","slug":"deploy-notes","status":"publish","type":"post","link":"https:\/\/ultering.com\/it4us\/?p=1667","title":{"rendered":"DEPLOY: NOTES"},"content":{"rendered":"<h2>DEPLOY REQUIREMENTS AND ISSUES<\/h2>\n<p>Be sure of something: if you have different environments, the same code that runs successfully were was born in, may fail on a new environment due many causes, like version differences and other system\u2019s idiosyncrasies .<\/p>\n<p>So, rule of thumb: always assume that a deploy on a new environment requires full testing procedure.<br>\nBelow, it is shown an example.<\/p>\n<h3>DEPLOY \u2013 ENVIRONMENT DIFFERENCES<\/h3>\n<p>SQL command executed successfully in a Local SQL Server 2012 instance installed at Nov, 2018.<\/p>\n<p><noscript><img decoding=\"async\" class=\"aligncenter size-full wp-image-1669\" src=\"https:\/\/ultering.com\/it4us\/wp-content\/uploads\/2018\/11\/sqlserver_10090_sql_success_short.png\" alt width=\"997\" height=\"275\" srcset=\"https:\/\/ultering.com\/it4us\/wp-content\/uploads\/2018\/11\/sqlserver_10090_sql_success_short.png 997w, https:\/\/ultering.com\/it4us\/wp-content\/uploads\/2018\/11\/sqlserver_10090_sql_success_short-300x83.png 300w, https:\/\/ultering.com\/it4us\/wp-content\/uploads\/2018\/11\/sqlserver_10090_sql_success_short-768x212.png 768w\" sizes=\"(max-width: 997px) 100vw, 997px\"><\/noscript><img decoding=\"async\" class=\"aligncenter size-full wp-image-1669 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20997%20275%22%3E%3C%2Fsvg%3E\" alt width=\"997\" height=\"275\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20997%20275%22%3E%3C%2Fsvg%3E 997w\" sizes=\"(max-width: 997px) 100vw, 997px\" data-srcset=\"https:\/\/ultering.com\/it4us\/wp-content\/uploads\/2018\/11\/sqlserver_10090_sql_success_short.png 997w, https:\/\/ultering.com\/it4us\/wp-content\/uploads\/2018\/11\/sqlserver_10090_sql_success_short-300x83.png 300w, https:\/\/ultering.com\/it4us\/wp-content\/uploads\/2018\/11\/sqlserver_10090_sql_success_short-768x212.png 768w\" data-src=\"https:\/\/ultering.com\/it4us\/wp-content\/uploads\/2018\/11\/sqlserver_10090_sql_success_short.png\"><\/p>\n<p>&nbsp;<\/p>\n<p>The same command fails on a server using a prior version of SQL Server.<\/p>\n<p><noscript><img decoding=\"async\" class=\"aligncenter size-full wp-image-1668\" src=\"https:\/\/ultering.com\/it4us\/wp-content\/uploads\/2018\/11\/sqlserver_10090_sql_failure_short.png\" alt width=\"978\" height=\"210\" srcset=\"https:\/\/ultering.com\/it4us\/wp-content\/uploads\/2018\/11\/sqlserver_10090_sql_failure_short.png 978w, https:\/\/ultering.com\/it4us\/wp-content\/uploads\/2018\/11\/sqlserver_10090_sql_failure_short-300x64.png 300w, https:\/\/ultering.com\/it4us\/wp-content\/uploads\/2018\/11\/sqlserver_10090_sql_failure_short-768x165.png 768w\" sizes=\"(max-width: 978px) 100vw, 978px\"><\/noscript><img decoding=\"async\" class=\"aligncenter size-full wp-image-1668 lazyload\" src=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20978%20210%22%3E%3C%2Fsvg%3E\" alt width=\"978\" height=\"210\" srcset=\"data:image\/svg+xml,%3Csvg%20xmlns%3D%22http%3A%2F%2Fwww.w3.org%2F2000%2Fsvg%22%20viewBox%3D%220%200%20978%20210%22%3E%3C%2Fsvg%3E 978w\" sizes=\"(max-width: 978px) 100vw, 978px\" data-srcset=\"https:\/\/ultering.com\/it4us\/wp-content\/uploads\/2018\/11\/sqlserver_10090_sql_failure_short.png 978w, https:\/\/ultering.com\/it4us\/wp-content\/uploads\/2018\/11\/sqlserver_10090_sql_failure_short-300x64.png 300w, https:\/\/ultering.com\/it4us\/wp-content\/uploads\/2018\/11\/sqlserver_10090_sql_failure_short-768x165.png 768w\" data-src=\"https:\/\/ultering.com\/it4us\/wp-content\/uploads\/2018\/11\/sqlserver_10090_sql_failure_short.png\"><\/p>\n<!--CusAds0-->\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>DEPLOY REQUIREMENTS AND ISSUES Be sure of something: if you have different environments, the same code that runs successfully were was born in, may fail on a new environment due many causes, like version differences and other system\u2019s idiosyncrasies . So, rule of thumb: always assume that a deploy on a new environment requires full &#8230; <a href=\"https:\/\/ultering.com\/it4us\/?p=1667\" class=\"more-link\">Read More<span class=\"screen-reader-text\"> &#8220;DEPLOY: NOTES&#8221;<\/span> &raquo;<\/a><\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[17,97,96],"tags":[],"class_list":["post-1667","post","type-post","status-publish","format-standard","hentry","category-database","category-devops","category-sql"],"_links":{"self":[{"href":"https:\/\/ultering.com\/it4us\/index.php?rest_route=\/wp\/v2\/posts\/1667","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ultering.com\/it4us\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ultering.com\/it4us\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ultering.com\/it4us\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/ultering.com\/it4us\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1667"}],"version-history":[{"count":4,"href":"https:\/\/ultering.com\/it4us\/index.php?rest_route=\/wp\/v2\/posts\/1667\/revisions"}],"predecessor-version":[{"id":2626,"href":"https:\/\/ultering.com\/it4us\/index.php?rest_route=\/wp\/v2\/posts\/1667\/revisions\/2626"}],"wp:attachment":[{"href":"https:\/\/ultering.com\/it4us\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1667"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ultering.com\/it4us\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1667"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ultering.com\/it4us\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1667"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}