Pushing Tab Coloring to Lots of Servers

DonFerguson

I like the tab coloring feature; however, it will be a chore to push it out individually to every instance for all DBAs. Is there an easier way to do this via script or other means?

Anu D

Looks like the information is stored in servers.xml file so if you copy that around that would work.

The XML file resides here: %localappdata%\Red Gate\SQL Prompt 6

Hope this helps.

DonFerguson

Yes, that helps.

In my case I was able to further take this information and query my Central Management server to generate the XML data needed.

Since I have a naming convention on the different environments, it was simply a matter of parsing the environment value from the name. I am providing it for the benefit of anyone else interested.

Obviously this query needs to be modified to meet the convention of a given organization's naming conventions, but here's a start. Modify as needed the output from this query below and paste results into the XML file following the <?xml version="1.0"?> line.

SELECT name
,category = CASE LEFT(name, 1)
WHEN 'D' THEN 'DEVELOPMENT'
WHEN 'S' THEN 'STAGING'
WHEN 'T' THEN 'TESTING'
WHEN 'P' THEN 'PRODUCTION'
ELSE 'PRODUCTION'
END
FROM msdb.dbo.sysmanagement_shared_registered_servers_internal
FOR XML PATH('server')
,ROOT('settings')