How to change default storage type SDE 10.1 on SQLServer 2008 R2?

02-05-2014 08:55 PM
Occasional Contributor III
I have to change a default storage type of SDE 10.1 on SQLServer 2008 R2.
1. How can I do it?
2. Is it enough to update ONLY ONE row (field config_string)(GEOMETRY->SDEBINARY) in dbo.SDE_dbtune table (where keyword='DEFAULTS' and parameter_name='GEOMETRY_STORAGE')?

Any ideas would be appreciated.
0 Kudos
1 Reply
Esri Esteemed Contributor
The 'sdedbtune' utility will upload a DBTUNE file into a database, but you can update the
GEOMETRY_STORAGE key using SQL as well.  The GEOMETRY type is a bit quirky, but
it's also usually faster than the 3-table SDEBINARY format.

- V
0 Kudos