[GIS] Convert from Geometry to SDE Binary storage type in SDE database

arcgis-10.1convertenterprise-geodatabasesql server

We have been battling performance issues between SQL 2012 and ArcGIS 10.1. One of the most common solution is to convert to SDE Binary storage. We know that this storage type is not as dynamic as the Geometry type. But we just opted to try to convert atleast one table in the database (assuming that it is possible).

Problem is, we are not sure on the correct procedure to do this. Do we do it on the database side? or in the ArcGIS side?

Thanks.

Best Answer

The simplest way is to copy the original feature class to a new one, specifying a DBTUNE keyword that will use SDEBINARY storage. There's probably a dozen additional ways, but they all involve a query and new table creation.

Related Question