I'm developing an application to retrieve data from an SQL Express server running on the machine's HMI. I have some of the named queries operational at this stage.1
I have a second identical machine running its own instance of SQL Express and will set up a separate database connection for it.
Question: what is the smart way to switch database connections (or switch the application's default database) when using named queries? (Any Perspective client will be looking at one machine or the other with selection by user.)