A SQL Remote question:
If I have set the remote FILE filelink directory within the database via, say
and also have set the SQLREMOTE environment variable to a different directory, am I right that the database option has higher precedence? (My tests with v184.108.40.20603 seems to imply that.)
I had expected the environment variable would have higher precedence, much like the SQLCONNECT connection parameters having higher precedence than those in a ODBC DSN...)
As to the background: We do set the directory fitting for the remotes. However, right after a re-extract we are doing an initial replication internally (to make sure it all works), and internally, the FILELINK uses a different directory structure. So I thought I could overwrite the database setting via the SQLREMOTE environment variable but that failed (i.e. it seems to be ignored). Therefore I guess I have to modify the remote option temporarily... and re-set it to the desired value after the internal tests have been passed.
You are correct that the environment variable is over-riden by the database setting. The order of precedence, from lowest to highest is :
Registry Setting Environment Variable Database Setting
answered 25 May '16, 09:57