#Database out of date how to#
#Database out of date upgrade#

After remedying any errors, you can run the analysis again by clicking Reanalyze.

#Database out of date how to#

Recommendations are provided along with any failed prerequisites suggesting how to resolve the issue. These issues should be researched and rectified prior to proceeding with the upgrade. Any prerequisites that have not been met will be displayed with a 'FAIL' or 'WARN' status. Prerequisites that have been met will be displayed with a 'PASS' status. In addition to checking the database version number, the installer/utility will also check for various prerequisites needed to perform the upgrade.

#Database out of date upgrade#

If the database does not require an upgrade, then the installer will state this and essentially skip the ARM upgrade process.ДЄs with the database upgrade, the database analysis process used in the EFT installer is actually performed by the Database Utility and is equivalent to running the utility with the '-action=PreviewUpgrade' command line option. As such, the version number for the database may not change as often as the EFT version. Across many builds and releases of the EFT application, the ARM database may not require any changes. The analysis step will determine whether the database requires an upgrade by examining the version number in the new version table. (EFT's upgrader does not check the database for fragmentation.) Administrators are urged to read the results carefully prior to continuing with the upgrade. The results of this analysis are displayed in an upgrade preview page of the installer. When upgrading from within the EFT installation process, the installer will analyze the database prior to performing the actual upgrade. (Refer to Database User Account Privileges > Upgrade for information on the required database user account privileges necessary to successfully upgrade.) You must provide the credentials for the EFT database user account, as opposed to the super-user accounts such as 'sa' or 'sys', because the upgrade process assumes it is operating as the database account that owns the schema to be upgraded.

This version number is maintained in a new table called 'TBL_SCHEMA_VERSION.' This new table is created as part of the initial ARM upgrade process when upgrading EFT.Дuring the upgrade, you will be prompted to provide the user credentials that should be used when connecting to the database. This version is used to determine if the database schema and data require an upgrade across various releases of the EFT application. Because the EFT installer uses the same Database Utility internally to perform the upgrade, the methods are synonymous.ДЄs part of this new approach to upgrading the ARM database, the database schema maintains an independent version number. You have the option of either upgrading the database during the upgrade process within the EFT Installer or choose to upgrade the database 'out of band' later using the Database Utility. This introduction describes in general how an EFT database upgrade works.ДЄ Database Utility ( DBUtility.exe) is used to upgrade the database, when applicable. Upgrading the EFT Database Upgrading the EFT Database