topic Re: Create Replica on SDE Table in Data Management Questions

Create Replica on SDE Table

PaulKroseman — Fri, 20 Jan 2012 12:56:36 GMT

I am trying to create a one way replica of an SDE Table. The replication is created and works for synchronizing changes but the child table starts at 0 records. It is not copying the original rows from the parent table when created. Feature Classes and Feature Datasets work just fine. My tables are Versioned and have Global IDs populated.
I am using the Create Replica tool from "Data Management Tools\Distributed Database" on ArcGIS 10 SP3.

Is there something I'm missing?

Thanks.

Re: Create Replica on SDE Table

NanaDei — Fri, 20 Jan 2012 16:06:29 GMT

The default behavior for replicating tables is 'Schema Only'.
To replicate the table/records, use the Create Replica wizard from the 'Distributed Geodatabase' toolbar in ArcMap and ensure that the 'Check Out' column in the 'Advanced Create Replica Options' is changed to "All Records".
Please review the attached screenshots.
There's an enhancement request to make the default behavior 'all records' instead of 'schema only'.

Thanks
[ATTACH=CONFIG]11332[/ATTACH]
[ATTACH=CONFIG]11333[/ATTACH]

Re: Create Replica on SDE Table

PaulKroseman — Fri, 20 Jan 2012 16:56:18 GMT

Thanks. The ArcMap wizard method worked.

Is it possible to set this option in the Create Replica tool?

Re: Create Replica on SDE Table

NanaDei — Wed, 25 Jan 2012 23:44:56 GMT

Since the default for replicating standalone tables is 'schema_only' the following workaround can be used with the 'Create Replica' tool.

>>Create a model using the 'Make Table View' and the 'Create Replica' tools.
> Pass the standalone table to the 'Make Table View' tool and set a filter in the expression. eg. Objectid>=1 can be used if the entire table is being replicated.
> Pass the output of the 'Make Table View' to the 'Create Replica' tool and define the various parameters.

Re: Create Replica on SDE Table

NidhinKarthikeyan — Thu, 19 Jun 2014 09:14:55 GMT

NIM-040283