Toad World® Forums

[toadss] Re: Change connection of all tabs


#1

[toadss] Re: Change connection of all tabs


#2

Alexander, I would really like more details on why you have made this statement.
From where I sit, the benefit may be there, so please explain !

@Alexander::

We have discussed this request and here the answer: its dangerous to have it
work like this. We used to have it work this way but changed it per request due
to performance and other issues.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn. com

678.414.0090 my cell Primary
image002.jpeg


#3

Alexander, I would really like more details on why you have made this statement.
From where I sit, the benefit may be there, so please explain !

@Alexander::

We have discussed this request and here the answer: its dangerous to have it
work like this. We used to have it work this way but changed it per request due
to performance and other issues.

Hank Freeman

Senior Systems, Database/Data Warehouse Architect

hfreeman@msn. com

678.414.0090 my cell Primary
image001.gif


#4

Here is the danger:

  1. Have the editor open with a script that you are working on with your
    development database.

  2. Close the development connection.

  3. Open a connection to the production database.

  4. Open up the development connection again.

  5. Execute the script in the editor from step one.

With our current implementation this will execute the script on the development
connection. With the previous (Or suggested new behavior) this would execute the
script on the production database since that was the first connection opened
after the editor was “orphaned” from its connection.

/Mauritz
image001.gif


#5

Here is the danger:

  1. Have the editor open with a script that you are working on with your
    development database.

  2. Close the development connection.

  3. Open a connection to the production database.

  4. Open up the development connection again.

  5. Execute the script in the editor from step one.

With our current implementation this will execute the script on the development
connection. With the previous (Or suggested new behavior) this would execute the
script on the production database since that was the first connection opened
after the editor was “orphaned” from its connection.

/Mauritz
image002.jpeg