Updating extended object definitions with new file server location

The way you execute the update_extended_object_script_location script depends on your database platform.

• To update file server references on Oracle
• To update file server references on SQL server

To update file server references on Oracle

1. In the file structure extracted from BSA<version>-<platform>.zip, copy the script from the following location (to a directory from which you can access SQL*Plus):

   Location	Script
   BSA<version>-<platform>/files/configurations/ db_scripts/oracle/utility/ update_extended_object_script_location/	update_extended_object_script_location.sql Important: You must add a forward slash / at the end of the script to complete the action.

2. Change (cd) to the directory where you copied the scripts.

3. Modify the update_extended_object_script_location.sql script file to update old_server and new_server variables before executing the script to update extended objects definitions which are stored on the file server.

   sqlplus <user> / <password> @update_extended_object_script_location.sql

To update file server references on SQL server

1. In the file structure extracted from BSA<version>-<platform>.zip, copy the scripts from the following locations to a directory from which you can access the sqlcmd utility:

   Location	Scripts
   BSA<version>-<platform>/files/configurations/ db_scripts/sqlserver/utility/ update_extended_object_script_location/	update_extended_object_script_location.sql

2. Change (cd) to the directory where you copied the scripts.

3. Modify the update_extended_object_script_location.sql file to update old_server and new_server variables before executing the script to update extended object definitions which are stored on the file server.

   sqlcmd -s <sqlsrv host>[\<instance>] -U <user> -d <database> -i update_extended_object_script_location.sql -o <file_server_check_sqlserver.out> Replace the variables with the following values:

   sqlsrv	Name of the SQL Server hosting the TrueSight Server Automation database.
   user	User name of a database user that has the privileges required to perform this operation.
   database	Name of the database.