Blue
White
Purple
Green
Red
Orange
Blue Light
White Light
Purple Light
Green Light
Red Light
Orange Light
Does anyone have a suggestion to export data as KML given spatial data fields are available in a connected SQL2008/2012 database? PHPRunner does an XML export so maybe KML is possible.
It's definitely possible however you will have to run this sort of code manually. You can find a sample script at https://developers.google.com/kml/articles/phpmysqlkml