Replicating a Table

[JoeBorgione]

First:  ArcGIS Server / Enterprise GDB 10.3.1 with Sql Server 2012 back end.  ArcGIS Desktop 10.3.1.

There are a couple of discussions related to my issue ( see: Non-spatial table replication  and https://community.esri.com/thread/111346 ) but they are with check out replicas.  My problem is when I replicate a non-spatial table from an Enterprise gdb parent to a file gdb child using Oneway Replication, the initial replicated table is empty.  My work around is to add a short integer field to the parent prior to replication.  Then I create the replica.  Then I go back to the parent and update  the short int field = 0 and sync. Since everything has changed, all the records come over.

Is this expected behavior for a Oneway Replica for a non-spatial table?

jskinner-esristaff‌

ASenGupta-esristaff‌

[JakeSkinner · Accepted solution]

Hi Joe,

When you are creating the replica, are you clicking the dropdown and selecting 'All Records'?  Ex:

You will need to check the option 'Show advanced options for overriding replica defaults when I click Next' to see this option.

[JoeBorgione]

For hecks sake, that was easy.

Thanks Jake !

#replication‌

[JakeSkinner]

Not sure why that's not the default, but I believe there is an enhancement request for this, and there is also an ArcGIS Idea:

https://community.esri.com/ideas/3541 

[JoeBorgione]

Noted and voted....