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 ?
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?
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.
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.