i need to change the geometry MDSYS.SDO_Geometry
to SDE.ST_Geometry
because that's required for migration (ArcGis 9.3 to Arcgis 10.5)
and those geometries are not compatible.
I tried to see how they built it but i don't understand how can i make it. I have the code for both of them if someone can help me.
MDSYS.SDO_GEOMETRY(
2002,
NULL,
NULL,
MDSYS.SDO_ELEM_INFO_ARRAY(1,2,1),
MDSYS.SDO_ORDINATE_ARRAY(-72.1047299999991,-41.4399799999992,-72.1057099999998,-41.4404200000008,-72.1062500000007,-41.4405299999999,-72.1072399999994,-41.4404900000009,-72.1090899999999,-41.4401600000001,-72.1096799999996,-41.4399900000008,-72.1102499999997,-41.4395100000002,-72.11064999878,-41.4390500012214,-72.1106899999995,-41.4390100000001))
SDE.ST_GEOMETRY(4,21,-69.5,-19.76245,-69.49831,-19.75843,0,0,NULL,NULL,0,0.00665337290908277,300003,'oracle.sql.BLOB@4f5a1e8d')
Well, finally and thanks for the cooperation from MT10 i make the migration of data whit the tool "Migrate Storage".
Just need a SDE connection and insert the data to convert. Just follow the instructions in the follow link: data-migration
Before you migrate... The following conditions must be met before you convert your data:
Tip: The list of supported coordinate systems that can be used with the SQL Server GEOGRAPHY type is in the SQL Server system view sys.spatial_reference_systems. If your geodatabase is in SQL Server 2008 or 2008 R2, feature classes migrated to the SQL Server GEOGRAPHY type cannot contain z- or m-coordinate values.