Jul 16, 2013 8:02:28 AM by Valentine
We are living in the age of windows – I’m in 10 different window app all day long. Very similar I work with my Sql Servers - I have about ten servers and permanently connected to a few of them to execute queries, compare data/schema, etc.
I told you another day how painful execution of the script on the wrong connection
Toad helps me visually differentiate my connections Just go to connection property window and check category at the bottom. Here is how my looks like (you can create your own categories and use your own colors):
Once you have assigned colors to the connection you can expect to see category color in Object Explorer, on every document tab and finally in the editor:
Here is another picture illustrating how category colors help me to differentiate test/production server.
There is also one tip: if I need to execute sql on another connection, I can switch existing editor to that connection with context menu on the document tab like shown on the picture below
And the color will be updated as it is specified in new connection.
I hope this post worth to read and can make your connections more colorful!
Have a good day!
Written by Valentine
I joined Quest Software back in 2004. I took a part in different initiatives and projects in company covering such areas as database security, change management, auditing and at the end stopped next to Toad products. This is quite interesting journey, which takes all of me: I'm generally cultivating the ideas in the product. Talking to outside audience to learn their needs. Helping people to achieve the goal.
Besides my other skills, here is my experience with database technologies: SQL Server, IBM DB2 LUW and less with z/OS, a little of Oracle.