Running the Nearby Query Installer
To run the Nearby Query installer:
Download the installer to the host from which you want to run the installation. The installer file name is AA_Enable_Nearby_Query_19.1.0.exe.
Run the installer.
Click Next on the Welcome screen.
Read and accept the license agreement, and then click Next.
Select the directory to copy the database update files to, and then click Next.
The default is C:\Accela\730NearbySearchDbUpdate.
Select the database type you are using (Oracle or MS SQL Server).
Click Yes or No to dismiss the confirm message βAre you upgrading a Multilingual database?β
Follow the appropriate steps for your setup:
If you select Oracle, complete the following information and click Next:
User Enter the name of the Oracle user with privileges to do database updates. Password Enter the password of the Oracle user. TNS Name Enter the TNS name for the database that you want to upgrade. If you select MS SQL Server, do the following:
Enter the DB Server information in any of the following formats, and then click Next.
IP,Port
ServerName,Port
IP\DBInstanceName
ServerName\DBInstanceName
ServerIP\DBInstanceName, Port
ServerName\DBInstanceName, Port
- Enter the following information to connect to the database, and then click Next.
User Enter the name of the MS SQL user with privileges to do database updates. Password Enter the password of the MS SQL user. TNS Name Enter the name for the database that you want to upgrade.
Click Install to copy the files to your host or click Back to review your previous settings.
Do any of the following.
Mark the Run DB Update Scripts check box and click Finish.
The Nearby Query installer runs the DB upgrade script against the specified database.
Clear the Run DB Update Scripts check box and click Finish.
After you complete the upgrade, you must locate the desired DB upgrade script and run the script manually.
Note:You can remove the Nearby Query installation. However, this only removes the SQL script files extracted to your local host. Remove mode does not roll back changes made to the database.