We have been encourage to migrate from Oracle to SQL server for multiple reasons. In doing a gap analysis, most of what we do seems pretty transportable.
The one thing we seem to be missing is sde.st_transform. 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. This is an absolute necessity to be able to do live.
Is there any solution at all ?