Is it possible to have an editor be able to change to what db it is connected to? Example... I have created a query that I have ran in a non production environment, it works well now I want to run that against a production environment. The way that I know how to do this is to open a new connection to production and a new editor window connected to production, cut and paste the sql from the editor connected to non-production into the production editor window. In SQL Nav you could just open a new environment, select that environment and it would prompt you do you want to connect to a new environment. This way you have 1 editor window open but multiple connections and you could switch between these on the fly. Does Toad have this feature?
Toad does have this feature. In the top left hand corner there is a icon called Change session for this window which function like in Sql Navigator.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center