Spatial Views & Replication

[ToddColes]

Has anyone attempted to use a spatial view in a geodatabase replication scenario?  We are considering utilizing a one way replication, but without being able to maintain our views it may not be the best option.  Any insight would be appreciated.

[BrentHoskisson]

I'm confused what you are attempting to do.  What have you tried? and what are your results?

I successfully replicate several layers to our SDE that serves data for the web.  I have spatial views built on these layers that display fine without ever having to worry about them.

My suggestion is if you are replicating one-way make sure you replicate into a non-versioned dataset.

[ToddColes]

I haven't actually tried anything yet, I'm just trying to find out if what I want to do is feasible first.

Basically, we have an SDE geodatabase that has a handful of feature classes and tables with quite a few spatial views.  Instead of connecting our web maps directly to these views, we would like to replicate the database and have the web connect to it.  This sounds similar to what you are doing.  Do you actually replicate the views, or just replicate the tables/feature classes and build the spatial views on the replica?

[BrentHoskisson · Accepted solution]

I don't think you can replicate a view.  We replicate the data sets.  The views just sit on top of those data sets.  Replicating the dataset automatically replicates the views without having to do anything else.

[JakeSkinner]

Hi Todd,

You will not be able to replicate a view.  In order for data to be replicated it needs to be register as versioned and contain GlobalIDs.  It is not possible to register a view as versioned.