topic Re: Spatial Views & Replication in Data Management Questions

Spatial Views & Replication

ToddColes — Thu, 19 Apr 2012 18:53:22 GMT

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.

Re: Spatial Views & Replication

BrentHoskisson — Thu, 19 Apr 2012 19:03:28 GMT

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.

Re: Spatial Views & Replication

ToddColes — Thu, 19 Apr 2012 19:25:30 GMT

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?

Re: Spatial Views & Replication

BrentHoskisson — Thu, 19 Apr 2012 19:29:51 GMT

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.

Re: Spatial Views & Replication

JakeSkinner — Fri, 20 Apr 2012 11:18:43 GMT

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.