[GIS] imported Mosaic Dataset images stored on ArcSDE server

enterprise-geodatabaseraster

I am trying to learn more about Mosaic Datasets and specifically how they interact with ArcSDE (SQL Server 2008). I read in How raster data is stored in a geodatabase that "…In the case of the mosaic dataset, this table remains empty, since the raster data for a mosaic dataset is not stored in the DBMS; instead, the raster data is referenced from an image file…"

Presumably this means that if I perform the Mosaic Dataset -> Add Rasters operation using files on the same machine as SDE then a file location is inserted into the murky depths of SDE. However, what if I connect to SDE remotely and Add Rasters from a different machine? I can only assume that SDE has a default directory to which the files are copied but I can't find anything about it, even in Mosaic datasets in a geodatabase in SQL Server.

I did find a table named <schema>.AMD_<mosaic name>_CAT which includes a field Uri ("A serialized Uniform Resource Identifier (URI) that is used to re-create the raster dataset") but it means nothing to me.

The test server in this case just has a single partition, but what if I wanted SDE to store mosaic dataset images on a separate drive for performance? How would I go about changing the default location, or even finding out what it is?

Any input very much appreciated.

Best Answer

I think by design that is the beauty of mosaic datasets.
Load all your imagery and manage many aspects of them
Including foootprints, searching, Date series, etc.
The dataset doesn't care from where the data comes.

So, (If I am correct) you need to load imagery to sde or the location you plan to serve it from.
See this esri help Creating a mosaic dataset

Mosaic datasets do not manage the raster data, meaning they do not move or alter the source files. They contain links to the source data.

If you want to serve your imagery from sde you need to load the data to sde.
See this esri help for information on the tablespace requirements and recommendations. Loading Larger Raster Datasets into SDE

There are a lot of locations in the help to find info on these subjects. List follows.
I believe raster catalogs are a bit redundant (with mosaic datasets) but here is that link
RasterToGeoDatabase Tool
Adding data to Mosaic Datasets
Importing or Loading
Creating a Mosaic Dataset (more)

Related Question