I have always done it manually. It is possible that they have added this capability to a QMC tool. But I have not seen or heard of this.
Also, a suggestion. Keep the name of the connection the same on both servers. Even if one points to a test db and the other points to a prod db.
That way you don't have to modify your apps when you move them.