Some time ago there were reported some challenges using switchServer - primarily around rawSQL I think. More recently there have been reports of loss of data broadcast when switching servers.
Is there a Servoy (or external) best practice for doing this without breaking our solution? We are currently doing / planning this:
a. Using a variable to set the server wherever it has been set in code (including rawSQL) at login.
b. Using switchServer at the same time as we set the global. This should change the dataprovider table source and everywhere else the server is called from forms etc?. So we go switchServer(defaultServerName,scmClientServerName).
c. Where necessary we still refer to our admin server explicitly where we need to (security etc).
Where will we likely face a challenge and what might that be?
Appreciate feedback for best practice.