Change all connections in Automation file

Toad Data Point
1

Hi,

We have multiple data bases in our test environment. When I want to switch from using one environment to another do I have to change all of the connection descriptions in all of the tasks in the TAS file? I noticed that when I changed the Test Connection in the Settings task and ran the TAS file it was still using the old connection.

Thanks

2

The Test/Prod connection settings should change all test connection matches to prod matches. If you find a situation where it doesn’t let us know and we will fix. This feature does not support multiple connections.

3

I have a similar issue, but we have three database environments: dev, test, and prod. Sounds like for now I’ll have to manually change the db connections, but any possibility TDP Settings task can support more than two environments in the future?

4

Thanks for the fast response!