Latest task has me ready to gouge out my eyeballs if I have to do this again. I'm interested in any useful explanations as to what's going on under the hood and whether there are any ways to make this simpler in the future.
The Task: We spun up a new instance of FM Server 16 to use as a testing platform. A developer we contract with had a development server for their tables in addition to his production server that we access via ODBC/ESS. I set up a new VM server (windows) and set up the needed DSN to connect to their Dev server in place of production. It seemed like a good idea at the time but maybe it was a mistake to use the same exact name and credentials for the DSN that linked to their Dev server?
In any case, with the new DSN set up on the new server, I copied over some back up files and quickly went to some layouts that reference this data and confirmed that I could see data and thus the external data source references TO's, DSN were all working.
On closer examination, even though the server had no copy of the original DSN, only the new one The files were still linking to the production server--not the dev server. The only way that I've found to get the files to link to the correct source is to add a totally new External Data Source entry and then go from TO to TO in my relationship graph updating each affected TO to refer to the new data source. Being able to select all TO's with the same data source and give them the same color and being able to see each shadow table on the tables tab with a list of any remaining occurrences helped a lot, but this has been an extremely tedious task and I shudder at the reality that come the passage of time, we'll want to drop in new copies of these files and I'll have to do this update all over again.
Anyone know why the files seemed to "remember" the DSN connection info even when hosted on a totally different server?
Anyone know of any tricks to reduce the pain? (SImply reslecting the DSN for the existing data source didn't work, neither did clicking the "sync" button.)