Installing the ST_Raster type in a local SQL Server database

If the ArcSDE command line tools are installed on the same server as the SQL Server database, follow these instructions to create the ST_Raster assembly and configure access to it:

Steps:
  1. Install the ArcSDE application server for SQL Server and command line tools.

    This installation can be downloaded from the Esri Customer Care Portal.

  2. Run the sdesetup command with the install_st_raster operation.
    sdesetup -o install_st_raster -d SQLSERVER
    -D ssgdb -s instance1
    
  3. Using SQL Server Management Studio, connect as any user that has access to the database where you installed ST_Raster, and test the installation of the ST_Raster type by executing the following SELECT statement against that database:
    SELECT <dbo or sde>.st_raster_util_getVersion();
    

    The query should return at least 1,000.

  4. Either create an ST_RASTER configuration keyword in the SDE_dbtune table with a RASTER_STORAGE parameter set to ST_RASTER or set the RASTER_STORAGE parameter under the DEFAULTS keyword to ST_RASTER.
    • If you want most or all of your raster data to be created using the ST_Raster type with ArcGIS software, set the RASTER_STORAGE parameter value under the DEFAULTS keyword to ST_RASTER.
      sdedbtune -o alter -k DEFAULTS -P RASTER_STORAGE
      -v ST_RASTER -i sde:sqlserver:serverb\ssdb -D ssgdb -u sde
      
    • If you want to create only some raster data with ST_Raster storage, add a keyword—ST_RASTER—to your SDE_dbtune table and include the RASTER_STORAGE parameter set to ST_RASTER and the UI_TEXT parameter.
      sdedbtune -o insert -k ST_RASTER -P RASTER_STORAGE 
      -v ST_RASTER -i sde:sqlserver:serverb\ssdb -D ssgdb -u sde
      
       sdedbtune -o insert -k ST_RASTER -P UI_TEXT -v UI_TEXT 
      -i sde:sqlserver:serverb\ssdb -D ssgdb -u sde
      

Related Topics

6/19/2015