Is there a way to change the database connection in multiple documents at the same time.
No, each database connection is saved to the document so each document has to have its own database connection modified.
One way to prevent this problem in the future is to use Named Database Connections in BarTender. This allows you to share a single connection configuration between multiple documents. You can see more about this in the BarTender Help.