topic Re: Replication of Geodatabase in Data Management Questions

Replication of Geodatabase

AkbarAkbar — Fri, 15 Jun 2012 17:33:24 GMT

Hi,

I have two ArcSDE Geodatabase (Oracle 11g R2), I want to replicate data (Two Way replication) between this two database. Both Database having some datasets are registered as Versioned and containing Geometric Network also have some unversioned dataset.
The first Database users are using for editing purpose and edits should come to second database as a part of overnight job.
Now my question is instead of using replication process given by ESRI, if I use my custom replication process (data updation using back end oracle package or procedure by creating Materialize view),
What is the risk involve in this? Is there any chance that my Geometric Network will get corrupted?
I am asking this question because the size of the databases are huge (Almost 1 TB), and I am expecting it will take long time to replicate(process given by ESRI).
I am using ArcGIS 10.

Please Help.....
Thanks

Re: Replication of Geodatabase

JakeSkinner — Mon, 18 Jun 2012 12:18:41 GMT

If you are replicating a very large amount of data, you may want to consider using the Register existing data option. If you have a fast method of transferring data between databases, such as a database dump, it may be easier to copy data from one database to another, then go through the Create Replica wizard with the option to register with existing data. This creates the replica versions needed to synchronize changes between the geodatabases but does not go through the lengthy process of copying data since it already exists in both locations. More information can be found here.

Re: Replication of Geodatabase

AkbarAkbar — Tue, 19 Jun 2012 07:13:51 GMT

Hi Jake,

Many thanks for your help, It was really helpful for me, but still I would like to know instead of using this process if I update tables using oracle package or procedure what is the risk involve in it? Is there any chance that network will get corrupted?
**
Apart from this :-
also I would like to ask how to do network rebuild on newly replicated data , as doing network rebuild will required to close all user connection from database, that is not possible because it is a 24X7 application.

Thanks in Advance....

Re: Replication of Geodatabase

JakeSkinner — Tue, 19 Jun 2012 09:40:01 GMT

There is a risk using oracle packages or procedures to create the replication due to the many tables associated with feature datasets/feature classes/tables/geodatabse objects (i.e. geometric networks, topologies, etc). Replication using this method is not supported by ESRI.

I'm not quite sure what you mean by a 'network rebuild'. Could you elaborate a little more on this?

Re: Replication of Geodatabase

AkbarAkbar — Tue, 19 Jun 2012 15:34:52 GMT

I have a dataset ( registered as Versioned ) having geometric network present in that dataset. Any editing in this dataset will come to second Database as a part of over night replication process. Hence I need to do Geometric network rebuild in newly replicated feature in second database. But problem is to rebuild the geometric network, I need to close all database connections, which is not feasible option for me (I am getting schema lock error).
Please advice.............

Many Thanks