topic Re: SQL Server st_transform equilavent in Geodatabase Questions https://community.esri.com/t5/geodatabase-questions/sql-server-st-transform-equilavent/m-p/828835#M4147 <HTML><HEAD></HEAD><BODY><P>Hi Jeff,</P><P></P><P>Unfortunately, Microsoft does not allow transformations through their ST functions like we do for Oracle and PostgreSQL DBMS's.&nbsp;</P><P></P><P>The only workaround that is going to work here is to use 2 spatial columns in the table in SQL Server. While we do not support multiple spatial columns when working with tables or views in ArcGIS, Microsoft does. So you could add a second spatial column in the WKID that you need and then create a view or query layer using only one of those columns for use in ArcGIS. Outside of this though, I can't think of another way around it.</P><P></P><P>Jonathan</P></BODY></HTML> Thu, 06 Sep 2018 16:15:37 GMT JonathanFarmer_oldaccount 2018-09-06T16:15:37Z SQL Server st_transform equilavent https://community.esri.com/t5/geodatabase-questions/sql-server-st-transform-equilavent/m-p/828834#M4146 <HTML><HEAD></HEAD><BODY><P>We have been encourage to migrate from Oracle to SQL server for multiple reasons.&nbsp; In doing a gap analysis, most of what we do seems pretty transportable.</P><P></P><P>The one thing we seem to be missing is sde.st_transform.&nbsp; We keep our data natively in State Plane, but create spatial views to show the data in different coordinate systems, or to add Lat/Long coordinates, or to union datasets in different systems.&nbsp; This is an absolute necessity to be able to do live.</P><P></P><P>Is there any solution at all ?&nbsp;</P></BODY></HTML> Wed, 05 Sep 2018 20:32:15 GMT https://community.esri.com/t5/geodatabase-questions/sql-server-st-transform-equilavent/m-p/828834#M4146 JeffPace 2018-09-05T20:32:15Z Re: SQL Server st_transform equilavent https://community.esri.com/t5/geodatabase-questions/sql-server-st-transform-equilavent/m-p/828835#M4147 <HTML><HEAD></HEAD><BODY><P>Hi Jeff,</P><P></P><P>Unfortunately, Microsoft does not allow transformations through their ST functions like we do for Oracle and PostgreSQL DBMS's.&nbsp;</P><P></P><P>The only workaround that is going to work here is to use 2 spatial columns in the table in SQL Server. While we do not support multiple spatial columns when working with tables or views in ArcGIS, Microsoft does. So you could add a second spatial column in the WKID that you need and then create a view or query layer using only one of those columns for use in ArcGIS. Outside of this though, I can't think of another way around it.</P><P></P><P>Jonathan</P></BODY></HTML> Thu, 06 Sep 2018 16:15:37 GMT https://community.esri.com/t5/geodatabase-questions/sql-server-st-transform-equilavent/m-p/828835#M4147 JonathanFarmer_oldaccount 2018-09-06T16:15:37Z