Convert coordinate systems using SQLGeometery

One of my shape files looks like this:

POLYGON (
  -91.513078999999991 36.970298, 
  -87.01993499999999 36.970298, 
  -87.01993499999999 42.508337999999995, 
  -91.513078999999991 42.508337999999995, 
  -91.513078999999991 36.970298)

Another file is using SRID 3857:

  • sql server tuning
  • Unable to figure out JDBC ClassNotFoundException (JTDS driver)
  • Delete duplicate rows from a table and referenced table microsoft sql server
  • Production uses of Table Value Parameters
  • SQL - The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
  • How to check that given time slot is already exists in SQL Server 2012
  • POLYGON (
      -10033572.109485552 4727287.954831399, 
      -10033571.708142675 4727287.954831399, 
      -10033571.708142675 4727288.1439229213, 
      -10033572.109485552 4727288.1439229213, 
      -10033572.109485552 4727287.954831399)
    

    Assuming I can figure out which coordinate systems are being used, how do I convert from one format to the other?

    One Solution collect form web for “Convert coordinate systems using SQLGeometery”

    Use the GeometryToGeometry function from Pro Spatial, chapter 8.

    Source code and data tables: http://www.apress.com/9781430234913

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.