{"id":2114,"date":"2021-10-21T20:38:23","date_gmt":"2021-10-21T20:38:23","guid":{"rendered":"https:\/\/stoneedge.com\/kb\/?post_type=ht_kb&#038;p=2114"},"modified":"2021-10-21T20:40:43","modified_gmt":"2021-10-21T20:40:43","slug":"upgrading-from-sql-express","status":"publish","type":"ht_kb","link":"https:\/\/stoneedge.com\/kb\/articles\/upgrading-from-sql-express\/","title":{"rendered":"Upgrading from SQL Express"},"content":{"rendered":"<h2>Overview<\/h2>\n<p>This article has links and information to give you the tools to upgrade from SQL Express to SQL Standard, Developer, or Enterprise.<\/p>\n<h2>Prerequisites<\/h2>\n<p>Hardware and Software Requirements<\/p>\n<ul>\n<li>Follow the links to required system documentation.\n<ul>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/sql-server\/install\/hardware-and-software-requirements-for-installing-sql-server-ver15?view=sql-server-ver15\">2019<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/sql-server\/install\/hardware-and-software-requirements-for-installing-sql-server?view=sql-server-ver15\">2017 &amp; 2016<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>You will need Administrative privileges for the machine where the SQL Server is to be upgraded.<\/p>\n<h2>Best Practices<\/h2>\n<ul>\n<li>Back up the Current Database file. See Microsoft&#8217;s document on <a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/relational-databases\/backup-restore\/create-a-full-database-backup-sql-server?view=sql-server-ver15\">SQL Backup<\/a>.<\/li>\n<li>Create a backup of the Stone Edge Program file before the upgrade.<\/li>\n<li>Ensure any customizations are documented and have a backup file.<\/li>\n<\/ul>\n<h2>Microsoft&#8217;s Documentation on SQL Upgrading<\/h2>\n<p>Please follow the links below for Microsoft&#8217;s various articles about upgrading your SQL Server.<\/p>\n<ul>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/install-windows\/upgrade-sql-server?view=sql-server-ver15\">Upgrade SQL Server<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/install-windows\/prepare-for-upgrade-by-running-data-migration-assistant?view=sql-server-ver15\">Prepare for an upgrade by running Data Migration Assistant<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/install-windows\/upgrade-to-a-different-edition-of-sql-server-setup?view=sql-server-ver15\">Upgrade to a Different Edition of SQL Server (Setup)<\/a><\/li>\n<li>Supported version &amp; edition upgrades.\n<ul>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/install-windows\/supported-version-and-edition-upgrades?view=sql-server-ver15\">SQL Server 2016<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/install-windows\/supported-version-and-edition-upgrades-2017?view=sql-server-ver15\">SQL Server 2017<\/a><\/li>\n<li><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/database-engine\/install-windows\/supported-version-and-edition-upgrades-version-15?view=sql-server-ver15\">SQL Server 2019<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Overview This article has links and information to give you the tools to upgrade from SQL Express to SQL Standard, Developer, or Enterprise. Prerequisites Hardware and Software Requirements Follow the links to required system documentation. 2019 2017 &amp; 2016 You will need Administrative privileges for the machine where the SQL&#8230;<\/p>\n","protected":false},"author":8,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":[],"ht-kb-category":[24],"ht-kb-tag":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.8.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Upgrading from SQL Express - Stone Edge Order Manager<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/stoneedge.com\/kb\/articles\/upgrading-from-sql-express\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Upgrading from SQL Express - Stone Edge Order Manager\" \/>\n<meta property=\"og:description\" content=\"Overview This article has links and information to give you the tools to upgrade from SQL Express to SQL Standard, Developer, or Enterprise. Prerequisites Hardware and Software Requirements Follow the links to required system documentation. 2019 2017 &amp; 2016 You will need Administrative privileges for the machine where the SQL...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/stoneedge.com\/kb\/articles\/upgrading-from-sql-express\/\" \/>\n<meta property=\"og:site_name\" content=\"Stone Edge Order Manager\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-21T20:40:43+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/stoneedge.com\/kb\/articles\/upgrading-from-sql-express\/\",\"url\":\"https:\/\/stoneedge.com\/kb\/articles\/upgrading-from-sql-express\/\",\"name\":\"Upgrading from SQL Express - Stone Edge Order Manager\",\"isPartOf\":{\"@id\":\"https:\/\/stoneedge.com\/kb\/#website\"},\"datePublished\":\"2021-10-21T20:38:23+00:00\",\"dateModified\":\"2021-10-21T20:40:43+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/stoneedge.com\/kb\/articles\/upgrading-from-sql-express\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/stoneedge.com\/kb\/articles\/upgrading-from-sql-express\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/stoneedge.com\/kb\/articles\/upgrading-from-sql-express\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/stoneedge.com\/kb\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Upgrading from SQL Express\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/stoneedge.com\/kb\/#website\",\"url\":\"https:\/\/stoneedge.com\/kb\/\",\"name\":\"Stone Edge Order Manager\",\"description\":\"Documentation for the Stone Edge Order Manager\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/stoneedge.com\/kb\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Upgrading from SQL Express - Stone Edge Order Manager","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":"https:\/\/stoneedge.com\/kb\/articles\/upgrading-from-sql-express\/","og_locale":"en_US","og_type":"article","og_title":"Upgrading from SQL Express - Stone Edge Order Manager","og_description":"Overview This article has links and information to give you the tools to upgrade from SQL Express to SQL Standard, Developer, or Enterprise. Prerequisites Hardware and Software Requirements Follow the links to required system documentation. 2019 2017 &amp; 2016 You will need Administrative privileges for the machine where the SQL...","og_url":"https:\/\/stoneedge.com\/kb\/articles\/upgrading-from-sql-express\/","og_site_name":"Stone Edge Order Manager","article_modified_time":"2021-10-21T20:40:43+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/stoneedge.com\/kb\/articles\/upgrading-from-sql-express\/","url":"https:\/\/stoneedge.com\/kb\/articles\/upgrading-from-sql-express\/","name":"Upgrading from SQL Express - Stone Edge Order Manager","isPartOf":{"@id":"https:\/\/stoneedge.com\/kb\/#website"},"datePublished":"2021-10-21T20:38:23+00:00","dateModified":"2021-10-21T20:40:43+00:00","breadcrumb":{"@id":"https:\/\/stoneedge.com\/kb\/articles\/upgrading-from-sql-express\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/stoneedge.com\/kb\/articles\/upgrading-from-sql-express\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/stoneedge.com\/kb\/articles\/upgrading-from-sql-express\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/stoneedge.com\/kb\/"},{"@type":"ListItem","position":2,"name":"Upgrading from SQL Express"}]},{"@type":"WebSite","@id":"https:\/\/stoneedge.com\/kb\/#website","url":"https:\/\/stoneedge.com\/kb\/","name":"Stone Edge Order Manager","description":"Documentation for the Stone Edge Order Manager","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/stoneedge.com\/kb\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb\/2114"}],"collection":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/comments?post=2114"}],"version-history":[{"count":1,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb\/2114\/revisions"}],"predecessor-version":[{"id":2115,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb\/2114\/revisions\/2115"}],"wp:attachment":[{"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/media?parent=2114"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=2114"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/stoneedge.com\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=2114"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}