For safety when moving among servers, I have the desktop backgrounds of my servers color coded as follows:
My workstation - green
Other developers' workstations - blue
Development - yellow
UAT - orange
Production - red
In SQL Server Management Studio, I've colored the status bar for any query window in the corresponding servers the same way.
It would be nice if I could color-code the two halves of the "compare to" window in SQL Compare and SQL Data Compare the same way, based on the server/instance name!
Even better, could it pull the color values from some SQL Server configuration data for the status bars I already am coloring?
Steve Knox commented
It would be cool to integrate this with SQL Prompt's color-coding settings.
It would also be nice to color-code the deployment process window itself (maybe the window frame).
Very important for safety. Can you prioritize this? Syncing to production and destroying data is a nightmare.
Another possibility to build on this is to be able to mark a server as production.
Add a setting that can be toggled on and off in the options. The setting would be to display an additional warning whenever making a change to production.
I've not run into a problem with this, though, as I am extra careful with all updates.
Would be good so we can actually see that we are going to move from a 'green' server to a 'red' server.
For the color coding in SQL server management studio i use SSMSToolsPack