Upgrading/Rebuilding the Database

OASIS utilizes the SAP SQL Anywhere 17 database, often referred to as SA17 or Adaptive Server Anywhere (ASA) for older versions. Migrating from ASA version 9 to any newer version of the database software requires the database to be unloaded and reloaded due to changes in the internal database structures between versions. This will require some downtime while all data is exported and re-imported into a new file. The database can also be rebuilt to repair broken indexes or to shrink the database if an archive has been performed. 

One of the biggest concerns is estimating the required amount of disk space before starting. Users should plan for the new database to be approximately the same size as the current database but should also plan for an extra 50% of the database size in free space to be used as temp space for the rebuild process. Note: if needed, the process may be performed using a USB connected drive. This will result in a slower rebuild than using internal storage. Contact customer support for more information.

Before beginning this process, complete the following actions:

• Ensure that you have a valid backup. For more information, click here. 
• Ensure a hard drive is available with enough disk space free. This will be 1.5 times the size of your current oasis.db file.
• Ensure OASIS V273 (or later) is installed. Note: the current installers are available at http://www.OasisSalesSoftware.com/OASIS/install.
• Ensure all users are logged out of OASIS.
• Stop the database Service by launching the ASA Configuration and then selecting "Stop."
• Rename the original directory to "OASIS_old" and create a new OASIS directory.

Starting the ASA Configuration Utility

1. Hit the Windows key and search for ASA Configuration.

2. Click the result to launch the application.

3. The Adaptive Server Anywhere- Configuration for OASIS window will appear.

Rebuilding the Database

1. Select Tools.

2 Select Rebuild Database.

3. The Select Database to Rebuild window will appear.

4. Select the existing oasis.db file in the OASIS_old directory. Note: ensure this database is current.

5. Click Open.

6. The Select Output Directory window will appear.

7. Locate the new OASIS directory on a drive that has 2 times the available space in the oasis.db file.

8. Click Open.

9. The Rebuilding Database window will appear, displaying progress for the database rebuild. Note: this program can take hours to run.

10. While the program is running, the status at the bottom of the window will show "Running" in green font. If the process completes with "Abnormal End" in red font, contact customer service.

11. Once the process is complete and the database has been rebuilt, select "Close."

12. Disable the old database. Note: it is recommended that users do not delete the old database unless a known good copy of the database exists somewhere else. If possible, rename the database file from "oasis.db" to "oasis_OLD.db"

13. Setup the database server to utilize the new database. For more information, click here.