Select to view content in your preferred language

Replication of Geodatabase

842
4
06-15-2012 10:33 AM
AkbarAkbar
Emerging Contributor
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
0 Kudos
4 Replies
JakeSkinner
Esri Esteemed Contributor
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.
0 Kudos
AkbarAkbar
Emerging Contributor
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....
0 Kudos
JakeSkinner
Esri Esteemed Contributor
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?
0 Kudos
AkbarAkbar
Emerging Contributor
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
0 Kudos