I believe if you use the exact same instance of the DSN for the ESS source and reset the connection settings of the DSN and the tables are exact clones It should work for you.
I would suggest running a test with an FDS install first or getting a firm answer from someone who might know for sure.
note all the "exact" references! so many variables.
Hopefully perfectly cloned tables.
We will see.
dsn switch worked
Great. I recall doing something like this a couple years ago but I didn't remember the details.
I believe I migrated an external MySQL web DB to a different server. Tables stayed the same but the address and credentials changed. Worked well.