Apologies- I worked out that the express edit tool makes it easier.
Nevermind. I see that I tediously have to edit every application and re-assign the new connection. That’s clever. Nothing quite like using a computer to make life easy.
in some video tutorialz, marsha did some example for dynamically change the database connection,
you can find it on youtube channel, i will try to search with your luck ;D