Using ogr2ogr I was able to import a shapefile into SQL server, but it was imported as a geometry data type and not compatible to compare it to latitude longitude as the points were not correct on the polygons.
gdal\bin\gdal\apps\ogr2ogr -overwrite -f MSSQLSpatial -lco SRID=4326 -lco GEOM_TYPE=geography -a_srs "GIS\Kentucky\HH001M01.prj" "MSSQL:server=.\;database=GISData;trusted_connection=yes" "GIS\Kentucky\HH001M01.shp"
The last command I ran was above, but it gave an error that the Latitude values must be between -90 and 90 degrees. Which makes sense, but I don't know how to apply the project correctly to get it to convert the shapefile to the right format.
Am I missing a parameter to ogr2ogr or have I specified something wrong?
HH001M01 is the data I am using here.