Promoting projects will always break the connection so has to be done out of hours when no users are active. It would also be useful to have an option to preserve connection permissions so not accidentally removed on promotion

This would be very useful to identify where obsolete versions of a dataset are still in use and aid housekeeping