Replicating a Table

728
4
Jump to solution
09-07-2016 07:07 AM
JoeBorgione
MVP Esteemed Contributor

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

can't wait to retire....
Tags (1)
0 Kudos
1 Solution

Accepted Solutions
JakeSkinner
Esri Esteemed Contributor

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.

View solution in original post

4 Replies
JakeSkinner
Esri Esteemed Contributor

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.

View solution in original post

JoeBorgione
MVP Esteemed Contributor

For hecks sake, that was easy.

Thanks Jake !

#replication

can't wait to retire....
0 Kudos
JakeSkinner
Esri Esteemed Contributor

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
MVP Esteemed Contributor

Noted and voted....

can't wait to retire....
0 Kudos