topic Re: Dataset Change Detection & Sync in Data Management Questions

Dataset Change Detection & Sync

User35489 — Mon, 18 Nov 2013 04:19:34 GMT

Good Day Gurus,

We have a geodatabase A and B, we copied all the data of A to B few months ago. In other words A and B were similar few months ago. But, since then some datasets in A has been updated by users where as B remained same with no changes.
Now my question is, i want to implement all changes made in some datasets from A to B, what is the best option to do so ?

Thanks for you inputs
With Regards
-AS

Re: Dataset Change Detection & Sync

EmadAl-Mousa — Mon, 18 Nov 2013 05:08:50 GMT

Replication/Synchronization process.

Re: Dataset Change Detection & Sync

MarcoBoeringa — Mon, 18 Nov 2013 14:36:55 GMT

Replication/Synchronization process.

For some more detail, see these Help topics:
Understanding distributed data
Replicas and geodatabases

Re: Dataset Change Detection & Sync

User35489 — Tue, 19 Nov 2013 02:17:44 GMT

For some more detail, see these Help topics:
Understanding distributed data
Replicas and geodatabases

Hi,
Thanks all for your reply,
Actually i have gone through these things, but as my data is non-versioned and doesnot have global id's i am looking for an alternate solution. Is there any alternative which could let me acheive this task Guys?

-AS

Re: Dataset Change Detection & Sync

VinceAngelo — Tue, 19 Nov 2013 02:28:49 GMT

Sure, there's an alternative, but it involves serious work. For each table you'd need to
compile an MD5SUM (or other perfect hash function) across all the columns for each
row in both database instances. Then you'd need to build views to identify rows in
one instance but not the other, and vice versa, plus one for all the rows with changed
values. It took me four months to build a system to implement this with *one* table.

All in all, copying the entire database over again is a lot easier.

- V

Re: Dataset Change Detection & Sync

EmadAl-Mousa — Tue, 19 Nov 2013 02:35:06 GMT

there is an oracle product called "Oracle GoldenGate". I personally did not use it before . the repliation using this product is from DBMS level so i am not sure if geodatabase replication will be consistent.

Re: Dataset Change Detection & Sync

User35489 — Tue, 19 Nov 2013 04:28:32 GMT

I think i need to remove and export the datasets, its more reliable and easier.

Thanks
-AS