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.– PropperCommented Sep 19, 2019 at 5:44
-
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.– Ayaz49Commented Sep 19, 2019 at 6:29
Add a comment
|