topic Re: Non-spatial table replication in Data Management Questions

Non-spatial table replication

JacksonTrappett — Wed, 28 Dec 2011 22:05:56 GMT

SDE 10.0 SP2:

We have one-way replication set up between two SDE 10.0 SP2 geodatabases, and it is working fine, no errors. All of the spatial tables replicate correctly. We have one non-spatial table, that also replicates, but on the child database, it is always blank, even though the parent has rows. Has anyone else seen this, or know how to fix it?

The non-spatial table is versioned and has global IDs on the parent side.

Re: Non-spatial table replication

JakeSkinner — Thu, 29 Dec 2011 09:40:20 GMT

By default, when replicating tables the 'Check Out' for the table is set to Schema Only rather than 'All Records'. You will need to go into the advanced options when creating the replica (screen1.png). Then you can set the 'Check Out' to 'All Records' (screen2.png).

Re: Non-spatial table replication

JakeSkinner — Thu, 29 Dec 2011 09:48:06 GMT

Re: Non-spatial table replication

JacksonTrappett — Fri, 30 Dec 2011 15:50:13 GMT

Good to know, thanks!

Re: Non-spatial table replication

JamalNUMAN — Sun, 16 Jun 2013 19:42:24 GMT

By default, when replicating tables the 'Check Out' for the table is set to Schema Only rather than 'All Records'. You will need to go into the advanced options when creating the replica (screen1.png). Then you can set the 'Check Out' to 'All Records' (screen2.png).

Hi Jake,

I�??m experiencing the same problem. May you please have a look on the thread below:

http://forums.arcgis.com/threads/86754-Tables-participating-in-a-replica-generated-empty?p=306636&posted=1#post306636

Best

Jamal

Re: Non-spatial table replication

AsrujitSengupta — Mon, 17 Jun 2013 11:31:33 GMT

Jamal,

This is by design.

Please have a look at the below link for more details:
[ NIM040283 - Using GP tool (create replica) to create replica and set ALL_ROWS for expand feature classes and tables, the attribute table only has its schema replicated.]

http://support.esri.com/en/bugs/nimbus/TklNMDQwMjgz

You can also have a look at the below post for a good workaround:
http://forums.arcgis.com/threads/481...604#post166604 (look at the last post)

Hope this helps!

Regards,

Re: Non-spatial table replication

JamalNUMAN — Mon, 17 Jun 2013 17:58:21 GMT

Jamal,

This is by design.

Please have a look at the below link for more details:
[ NIM040283 - Using GP tool (create replica) to create replica and set ALL_ROWS for expand feature classes and tables, the attribute table only has its schema replicated.]

http://support.esri.com/en/bugs/nimbus/TklNMDQwMjgz

You can also have a look at the below post for a good workaround:
http://forums.arcgis.com/threads/481...604#post166604 (look at the last post)

Hope this helps!

Regards,

Thank you Asrujit for the help,

My non-spatial table is intended to be versioned and wanted to have same behaviour as for the spatial data when replica is created.

Is there a solution in 10.2 such that non-spatial data is replicated when �??create replica�?� is used?