Updating remote path depot object locations

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

• To update remote depot path location references on Oracle
• To update file server references on SQL server

To update remote depot path location references on Oracle

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

   Location	Script
   TSSA<version>-<platform>/files/configurations/ db_scripts/oracle/utility/ update_depot_object_location_remote_path/	update_depot_object_location_remote_path.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_depot_object_remote_location.sql script file to update old_server and new_server variables before executing the script to update remote depot object paths.

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

To update file server references on SQL server

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

   Location	Scripts
   TSSA<version>-<platform>/files/configurations/ db_scripts/sqlserver/utility/ update_depot_object_location_remote_path/	update_depot_object_location_remote_path.sql

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

3. Modify the update_depot_object_remote_location.sql file to update old_server and new_server variables before executing the script to update remote depot object paths.

   sqlcmd -s <sqlsrv host>[\<instance>] -U <user>
   -d <database> -i update_depot_object_location_remote_path.sql -o
   update_depot_object_location_remote_path.out

   Replace the variables with the following values: