topic Re: Replicating edited feature class data outside of SDE to SDE server, Automatically? in Data Management Questions

Replicating edited feature class data outside of SDE to SDE server, Automatically?

ChrisGoessl — Tue, 03 Feb 2015 18:33:35 GMT

Simple but complex question:

We just recently started SDE for my agency. I have a user that only has GIS Basic, but sometimes needs to edit street sign information. Since I can not give them edit in SDE, my thought is to create a Feature Dataset that they will be able to edit, then replicate the data between the Dataset and the SDE system.

Is this even possible to replicate the data outside of SDE to SDE?

If the feature class already has GlobalID, and tracking turn on: will these be auto-generated by someone that does not have a license greater than Basic edition?

Is there a way to create an automated script to do this?

Any direction or thoughts would be greatly appreciated before I tackle this issue.

Re: Replicating edited feature class data outside of SDE to SDE server, Automatically?

TimWitt2 — Tue, 03 Feb 2015 18:42:44 GMT

Hey Chris,

Did you think about maybe start using versioning? Even if he only knows basic ArcGIS, versioning is just like editing but puts a buffer between him and SDE.

ArcGIS Help 10.1

SDE --> QC/QA version --> Editor Version

Tim

Re: Replicating edited feature class data outside of SDE to SDE server, Automatically?

JoeBorgione — Tue, 03 Feb 2015 18:56:08 GMT

Tim- I think he means that the user only has a BASIC (ArcView) License, so he can't edit an SDE database.

Chris- with two-way replication you are limited to SDE and SDE. It does not have to be an Enterprise SDE, personal SDE will suffice, but since replication is built on versioning, shapefiles, personal, and file geodatabases can not participate.

Re: Replicating edited feature class data outside of SDE to SDE server, Automatically?

TimWitt2 — Tue, 03 Feb 2015 18:57:16 GMT

Ohhhhh, you are right my bad

Re: Replicating edited feature class data outside of SDE to SDE server, Automatically?

JakeSkinner — Tue, 03 Feb 2015 19:02:00 GMT

Hi Chris,

You can create a Check Out Replica. This will allow you replicate data from an SDE geodatabase to a File Geodatabase. However, you can only synchronize the changes back one time. Therefore, you would need to re-create the replica after each synchronization.

Editor tracking is available at all levels, so when you create the replica Editor Tracking will automatically be enabled for the child feature class. GlobalIDs will carry over during the replication as well.

Yes, you could create a model to create the Check Out replica, and then export the model to a python script if needed.

Re: Replicating edited feature class data outside of SDE to SDE server, Automatically?

JoeBorgione — Tue, 03 Feb 2015 19:05:43 GMT

Good call Jake- I forgot about check out replication

Re: Replicating edited feature class data outside of SDE to SDE server, Automatically?

LuciHawkins — Tue, 03 Feb 2015 19:46:31 GMT

You could accomplish this with a Two-way replica. Someone with a Standard or Advanced license would have to perform the replication process.

See Replication help here:ArcGIS Help 10.1

Thanks,

Luci

Yep, forgot about both databases needing to be SDE. Two-way wont work in this case, bummer!

Re: Replicating edited feature class data outside of SDE to SDE server, Automatically?

ChrisGoessl — Wed, 04 Feb 2015 18:56:55 GMT

This seems to work. However I need to create a Global ID for the SDE in the data before replicating. (Need to shut down the services first).

Thanks for the insight.

Chris Goessl