{"id":24397,"date":"2024-02-15T14:53:34","date_gmt":"2024-02-15T22:53:34","guid":{"rendered":"https:\/\/docs.extraview.com\/v25\/book\/upgrade-database-schema-4\/"},"modified":"2025-02-24T15:28:32","modified_gmt":"2025-02-24T23:28:32","slug":"upgrade-database-schema-4","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/windows-environment-1\/upgrade-database-schema-4\/","title":{"rendered":"Upgrade the Database Schema"},"content":{"rendered":"<p class=\"textGreyBg\">This step is required only if you are upgrading an existing version of ExtraView. If you are performing a new installation, you will have been provided with a database backup file that you will import into your Database installation instead. You can skip to the section that matches your selected Database &#8211; <a href=\"v25\/oracle-database-configuration-1\/\">Oracle<\/a>, <a href=\"v25\/sql-server-database-configuration-1\/\">SQL Server<\/a>, or <a href=\"v25\/mysql-database-configuration-1\/\">MySQL<\/a> Database Configuration now.<\/p>\n<p class=\"required\">You must backup your database before performing this step. ExtraView Corporation cannot guarantee that upgrades will complete successfully, therefore it is essential that you are able to revert to your existing installation.<\/p>\n<p>You should take a full export of your database before running any of the following upgrade scripts. This will allow you to roll back to the previous version of ExtraView if there are any problems arising from the upgrade. Edit the following file:<\/p>\n<p class=\"fixedWidthFont\">C:\\ExtraView\\Tomcat7\\webapps\\ev\\jWEB-INF\\data\\runWindows.bat<\/p>\n<p>Replace the following lines with the appropriate values for your system:<\/p>\n<p class=\"fixedWidthFont\">runPatches.bat C\\:ExtraView\\jre7-67 C:\\ExtraView\\Tomcat7 C:\\ExtraView\\Tomcat7\\webapps\\evj<\/p>\n<p>Replace <span class=\"fixedWidthFont\">C:\\ExtraView\\jre7-67<\/span> with your path to your Java<br \/>\nReplace <span class=\"fixedWidthFont\">C:\\ExtraView\\Tomcat7<\/span> with your path to your Tomcat<br \/>\nReplace <span class=\"fixedWidthFont\">C\\:ExtraView\\Tomcat7\\webapps\\evj<\/span> with your path to your evj folder.<\/p>\n<p>Now save and exit from the editor.<\/p>\n<p>To upgrade the database, now run <span class=\"fixedWidthFont\">runWindows.bat<\/span> from a Windows\/DOS Command line so that you can monitor the progress of the upgrade.<\/p>\n<p>The upgrade process initiated by the above command looks at your installation to determine exactly which version of code and which version of the database schema is active. The process will then apply all the patches to bring your system up to the current level. Some patches are very simple, some are more complex, and the time taken is dependent on the amount of data in your database.<\/p>\n<p>As the individual patches are applied, you will see many lines of text scroll past on the screen. At some point, depending on the amount of data in your system, the patches may appear to \u201chang\u201d while they perform large operations on the database \u2013 allow a reasonable amount of time (possibly 20 minutes or more) before you assume there is a problem with any individual part of the upgrade process. If you have any questions, please contact ExtraView Corporation.<\/p>\n<p>Once the script has finished running, and you are returned back to a command prompt, and your upgrade to the database is complete.<\/p>\n<p>For your reference, there is a log of the changes made to the database in the directory named <span class=\"fixedWidthFont\">C:\\ExtraView\\Tomcat7\\webapps\\evj\\WEB-INF\\logs<\/span>. These are held in a .log file (the exact name is specified in the Configuration.properties file). It is recommended that you save that file until you have verified your upgrade, so that the ExtraView Support can review this with you if you run into any issues. You can look through the log file to observe if any errors were generated during the upgrade process.<\/p>\n<h3>Oracle Database Upgrade Requirements<\/h3>\n<p>This step is only required if you are running Oracle as your database. ExtraView has been affected by bugs in a number of Oracle releases. If you are running a version of Oracle prior to Oracle 11.2.0.2, you should upgrade your installation. If you have access to Oracle Metalink, you should download the patch set from there. If not, ExtraView Corporation can provide you with information on how to retrieve the appropriate patch set.<\/p>\n<h3>Microsoft SQL Server Database Upgrade Requirements<\/h3>\n<p>This step is only required if you are running SQL Server as your database. ExtraView now requires SQL Server 2008 or later. If you are running an earlier version, you must upgrade your software.<\/p>\n<h3>MySQL Database Upgrade Requirements<\/h3>\n<p>This step is only required if you are running MySQL as your database. \u00a0ExtraView now requires MySQL 5.6. \u00a0If you are running an earlier version, you must upgrade your software.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This step is required only if you are upgrading an existing version of ExtraView. If you are performing a new installation, you will have been provided with a database backup file that you will import into your Database installation instead. You can skip to the section that matches your selected Database &#8211; Oracle, SQL Server,&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":24391,"menu_order":10,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_lmt_disableupdate":"no","_lmt_disable":"","_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"class_list":["post-24397","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Upgrade the Database Schema - Product Documentation<\/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:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/windows-environment-1\/upgrade-database-schema-4\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Upgrade the Database Schema - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"This step is required only if you are upgrading an existing version of ExtraView. If you are performing a new installation, you will have been provided with a database backup file that you will import into your Database installation instead. You can skip to the section that matches your selected Database &#8211; Oracle, SQL Server,...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/windows-environment-1\/upgrade-database-schema-4\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2025-02-24T23:28:32+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=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/windows-environment-1\/upgrade-database-schema-4\/\",\"url\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/windows-environment-1\/upgrade-database-schema-4\/\",\"name\":\"Upgrade the Database Schema - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\"},\"datePublished\":\"2024-02-15T22:53:34+00:00\",\"dateModified\":\"2025-02-24T23:28:32+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/windows-environment-1\/upgrade-database-schema-4\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/windows-environment-1\/upgrade-database-schema-4\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/windows-environment-1\/upgrade-database-schema-4\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ExtraView 25\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Installation &#038; Upgrade Guide\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Software Installation &#038; Upgrades\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Windows Environment\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/windows-environment-1\/\"},{\"@type\":\"ListItem\",\"position\":6,\"name\":\"Upgrade the Database Schema\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"name\":\"ExtraView Product Documentation\",\"description\":\"ExtraView Documentation\",\"publisher\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\",\"name\":\"ExtraView Corporation\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"contentUrl\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"width\":512,\"height\":512,\"caption\":\"ExtraView Corporation\"},\"image\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Upgrade the Database Schema - Product Documentation","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:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/windows-environment-1\/upgrade-database-schema-4\/","og_locale":"en_US","og_type":"article","og_title":"Upgrade the Database Schema - Product Documentation","og_description":"This step is required only if you are upgrading an existing version of ExtraView. If you are performing a new installation, you will have been provided with a database backup file that you will import into your Database installation instead. You can skip to the section that matches your selected Database &#8211; Oracle, SQL Server,...","og_url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/windows-environment-1\/upgrade-database-schema-4\/","og_site_name":"Product Documentation","article_modified_time":"2025-02-24T23:28:32+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/windows-environment-1\/upgrade-database-schema-4\/","url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/windows-environment-1\/upgrade-database-schema-4\/","name":"Upgrade the Database Schema - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v25\/#website"},"datePublished":"2024-02-15T22:53:34+00:00","dateModified":"2025-02-24T23:28:32+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/windows-environment-1\/upgrade-database-schema-4\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/windows-environment-1\/upgrade-database-schema-4\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/windows-environment-1\/upgrade-database-schema-4\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":2,"name":"ExtraView 25","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":3,"name":"Installation &#038; Upgrade Guide","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/"},{"@type":"ListItem","position":4,"name":"Software Installation &#038; Upgrades","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/"},{"@type":"ListItem","position":5,"name":"Windows Environment","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/installation-upgrade-guide-1\/software-installation-upgrades-1\/windows-environment-1\/"},{"@type":"ListItem","position":6,"name":"Upgrade the Database Schema"}]},{"@type":"WebSite","@id":"https:\/\/docs.extraview.com\/v25\/#website","url":"https:\/\/docs.extraview.com\/v25\/","name":"ExtraView Product Documentation","description":"ExtraView Documentation","publisher":{"@id":"https:\/\/docs.extraview.com\/v25\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/docs.extraview.com\/v25\/#organization","name":"ExtraView Corporation","url":"https:\/\/docs.extraview.com\/v25\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/","url":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","contentUrl":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","width":512,"height":512,"caption":"ExtraView Corporation"},"image":{"@id":"https:\/\/docs.extraview.com\/v25\/#\/schema\/logo\/image\/"}}]}},"taxonomy_info":[],"featured_image_src_large":false,"author_info":{"display_name":"carl.koppel","author_link":"https:\/\/docs.extraview.com\/v25\/author\/carl-koppel\/"},"comment_info":0,"_links":{"self":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24397","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/comments?post=24397"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24397\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/24391"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/media?parent=24397"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}