Updating file server references

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

• To update file server references on Oracle
• To update file server references on SQL server
• Where to go from here

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/file_server_change/	file_server_change_oracle.sql

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

3. Execute the following SQL*Plus command to change all file server references so they point to the new default file server:

   The [confluence_table-plus] macro is a standalone macro and it cannot be used inline. Click on this message for details.
   This macro generates standalone content. As a consequence you need to make sure to use a syntax that separates your macro from the content before and after it so that it's on a line by itself. For example in XWiki Syntax 2.0+ this means having 2 newline characters (a.k.a line breaks) separating your macro from the content before and after it.
   Running this command produces output similar to the following example:

   The [confluence_table-plus] macro is a standalone macro and it cannot be used inline. Click on this message for details.
   This macro generates standalone content. As a consequence you need to make sure to use a syntax that separates your macro from the content before and after it so that it's on a line by itself. For example in XWiki Syntax 2.0+ this means having 2 newline characters (a.k.a line breaks) separating your macro from the content before and after it.
   The number of rows updated by each update statement will vary in your database.

4. To be certain that all references point to the new file server, run the file_server_check script again (see Checking-file-server-references). The output should identify only one file server, and its values should be those of the new file server and storage location.

To update file server references on SQL server

1. In the file structure extracted from BSA<version>-<platform>.zip, copy the script 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/file_server_change/	file_server_change_sqlserver.bat file_server_change_sqlserver.sql

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

3. Change all file server references so they point to the new default file server by running the following command:

   The [confluence_table-plus] macro is a standalone macro and it cannot be used inline. Click on this message for details.
   This macro generates standalone content. As a consequence you need to make sure to use a syntax that separates your macro from the content before and after it so that it's on a line by itself. For example in XWiki Syntax 2.0+ this means having 2 newline characters (a.k.a line breaks) separating your macro from the content before and after it.
   Replace the variables with the following values:
4. To be certain that all references point to the new file server, run the file_server_check script again (see Checking-file-server-references). The output should identify only one file server, and its values should be those of the new file server and storage location.

Where to go from here

If you have extended objects in your environment, see Updating-extended-object-definitions-with-new-file-server-location