I know, but tbh i find it confusing.
Especially this page: Changing the file server from one location to another - BMC Server Automation 8.9
Since it talks about:
- To change the location of the file server
- To move files from one location to another
And i don't really understand what it says, as in the "move files" section it refeences the scripts again ?!
Please add your comment directly to the doc page and the Tech Writers will review it with the aim of making it clearer
there's really no point to the 'change file server' sql script anymore since 8.1. prior to 8.1 the depot_object_location table held the location of the files so the script would do a replace of the string names in there.
in 8.1 we moved that out to 'file_location' and 'file_server' so the file server url is always a construction of the host + file server root from file_server plus the relative_path from file location. once you make the change via blasadmin, that updates the file_server table and immediately effects all the file_location entries.
the only sql script that's useful on there is the update_extended_object one because the extended objects aren't related to the file_location table, and i wrote another one for the 'remote_path' in depot_object_location for when you have things 'on' the file server like patches but they aren't 'in' the file server that should be in 8.8+ db files somewhere.