topic Re: Applying schema changes on a esri geodatabase two-way replica set in Data Management Questions

Applying schema changes on a esri geodatabase two-way replica set

SteenRasmussen — Tue, 27 Nov 2012 08:31:34 GMT

I have an Esri geodatabase two-way replica set. I need to update the schema on both databases in the replica set. Esri describes doing this using ArcGIS schema tools (compare/export/import replica schema - see here).

I have control of both databases in the replica set and I would prefer to make a python script, which updates the schema and run that on both databases in the replica set.

Are there potential problems with applying the schema changes to both databases instead using Esri's schema tools?

I use arcsde 10.0 (service pack 3).

This question has first posted here: http://gis.stackexchange.com/questions/39311/applying-schema-changes-on-a-esri-geodatabase-two-way-replica-set

Re: Applying schema changes on a esri geodatabase two-way replica set

BirajaNayak — Wed, 28 Nov 2012 21:46:17 GMT

Please see the below link for schema changes Best Practices. It states " In general, it is best to avoid schema changes. Schema changes can lead to inconsistencies among replicas, and the extra task of applying schema changes can increase performance costs. However, there are cases when schema changes must be applied".

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//00270000003w000000.htm

If it is absolutely necessary to change schema on replica data then please follow the procedure of export, compare and import schema changes tool. In this workflow, you can avoid duplication of your effort and maintain consistency in both parent and child geodatabase.

Hope this clarifies your queries.

Re: Applying schema changes on a esri geodatabase two-way replica set

MarcoBoeringa — Thu, 29 Nov 2012 19:10:13 GMT

Reading about the process and Geoprocessing Tools available for this type of replica schema change synchronization in the Help, will there be / is planned any future role of X-Ray for ArcCatalog in this type of process when X-Ray is updated to support enterprise geodatabases?:

X-Ray for ArcCatalog (ArcGIS 10) (Blog)

Introduction to X-Ray for ArcCatalog (Video)

Re: Applying schema changes on a esri geodatabase two-way replica set

BirajaNayak — Thu, 29 Nov 2012 20:24:15 GMT

No information available at this moment of X-ray for enterprise geodatabase.
Please put your suggestion on Idea site "http://ideas.arcgis.com/" which has more chance of quick consideration if more people vote for this idea.