topic Re: Geodatabase repilication in Data Management Questions

Geodatabase repilication

MagusTan — Thu, 09 May 2013 13:55:46 GMT

I'm new to arcgis and its applications.

We have the full suite of arcgis solutions (arcgis server, desktop, arcgis sde) - 10.1

We have a requirement...

geodatabase (A & B)
A & B reside on 2 different server but connected via LAN
A will be updated
B will be a replica of A

May I know what is the best solution to this issue? the geodatabase can be hosted on oracle DB, personal geodatabase or geodatabase file.

I know that arcgistools has the functions to replicate and sync but according to my friend. the synchronization has to been done manually. (creeate a script and execute it periodically.

Is there a way to mirror those 2 geodatabase on the fly/real-time?

Re: Geodatabase repilication

JoeBorgione — Thu, 09 May 2013 14:05:29 GMT

Sounds like a pretty straight forward case of one-way replication; parent to child. Database A should be the Oracle/Server parent db while Database B is the child and pretty much any flavor you want, but I would suggest a file geodatabase.

You might want to start here...

Re: Geodatabase repilication

MagusTan — Thu, 09 May 2013 21:09:44 GMT

Thanks for replying,

Yes I have read that topic

"Geodatabase replication synchronizes changes from specific ArcSDE geodatabase versions. DBMS replication, when used with an ArcSDE geodatabase, applies changes across all versions in the geodatabase.
Geodatabase replication supports all advanced geodatabase objects like topologies, relationships, and geometric networks. DBMS replication does not know how to properly replicate advanced geodatabase objects."

I prefer using DBMS replication, but it seems that they do not support geometric networks which my system require for network analysis.

From my understanding Geodatabase replication and syncrhonize requires a python script to be run periodically at an interval. Therefore additional maintenance. I'm trying to avoid such overheads, especially the client's side has a professional DBA but no available GIS specialist.

Re: Geodatabase repilication

MagusTan — Fri, 10 May 2013 01:48:17 GMT

May I know if there is a way to sync 2 personal geodatabase? Or the source must be an ArcSDE geodatabase.

"Creates a replica to a personal, file, or SDE geodatabase from a specified list of feature classes, layers, datasets, and/or tables in an ArcSDE geodatabase."

url: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//001700000016000000

Re: Geodatabase repilication

JoeBorgione — Fri, 10 May 2013 11:45:10 GMT

May I know if there is a way to sync 2 personal geodatabase? Or the source must be an ArcSDE geodatabase.

"Creates a replica to a personal, file, or SDE geodatabase from a specified list of feature classes, layers, datasets, and/or tables in an ArcSDE geodatabase."

url: http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//001700000016000000

You've found your answer as shown above. From SDE to your choice of db. Can't do it between two PGDBs.