I am trying to replicate a feature class from Oracle to MSSQL Server using one-way replication(parent-child) replication. The replication works when edits are made from ArcMap,since I have to insert bulk data in that version and finally replicate it therefore making edits/inserts from ArcMap is not feasible. Replication works on the default version and data in default version comes from a view that is created while registering the feature class as versioned. Therefore, I am inserting or editing data in that view. The data is also found in version's respective table i.e Add and Delete tables. But when I run synchronization, it does not migrate those changes to MSSQL Server made from SQL Developer.

  • Did you execute database compress before starting synchronisation? This will write back the changes from the Add and Delete tables to the business tables. – Propper 15 hours ago
  • I don't want the data in base tables but in the target replica and for that it is not necessary to be compressed to base tables. – Ayaz49 14 hours ago

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.