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

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

    LocationScript
    BBSA<version>-<platform>/files/configurations/
    db_scripts/oracle/utility/
    update_depot_object_remote_location/
    update_depot_object_remote_location.sql
  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_remote_location.sql

To update file server references on SQL server

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

    LocationScripts
    BBSA<version>-<platform>/files/configurations/
    db_scripts/sqlserver/utility/
    update_depot_object_remote_location/
    update_depot_object_remote_location.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_remote_location.sql -o 
    update_depot_object_remote_location.out

    Replace the variables with the following values:

    sqlsrv

    Name of the SQL Server hosting the BMC Server Automation database.

    user

    User name of a database user that has the privileges required to perform this operation.

    database

    Name of the database.

Was this page helpful? Yes No Submitting... Thank you

Comments