That’s what I don’t know, and that’s what I’ve tried to do.
The problem is this: server A, which hosts the workspace, is going to become inaccessible, and I need to be able to continue using that workspace on server B.
A) inaccessible in the network sense: domain name will no longer belong to you. In this case you get a new domain name and change in the Interviewer App settings (of every tablet) to point to a new domain name continuing to use the same server hardware (box A).
B) inaccessible in a physical sense: the hardware box of server A will be decommissioned (for example, machine’s warranty has expired and hence that physical device must not be used anymore). In that case get a new server C, and relocate everything from A to C (still keeping it separately from B), and replace the box A with box C retaining the same address (URL) for the interviewers.
Merging of instances A and B is generally not possible. B may already have a workspace that you move with different content, and even if it doesn’t it may have user accounts (e.g. “admin”, “interviewer1”) that is a different person with a different password, and a number of other, perhaps less obvious obstacles.
In practice however, it all also depends on the details you are not revealing, such as the survey timeline, degree of control over interviewers, etc. It may be possible to just create a new workspace in B, create assignments for outstanding interviews and at some point have the interviewers switch to a new server (after they finish what they have started already in A). Yes, you will have two exported databases in this case.
The Interviewer App will refuse to connect to a different server even in the case when that other server also has a user with the same name and even with the same password. So even if you somehow magically managed to relocate the data it will not work (the Interviewer app will not sync) due built-in security checks. In particular, you are going to get a message:
I understand the correct option would be to run the virtual machine from server A on a new server C, separate from server B.
Just so you know, the data collection phase in the field has already finished, so it wouldn’t be a problem if the devices couldn’t reconnect. All I need is to be able to access the web and view the interviews from survey, and have the original data there in case any edits are necessary.