topic Create Replica using arcpy in Python Questions

Create Replica using arcpy

AsteriosTselepis1 — Fri, 14 Oct 2016 12:06:01 GMT

I am creating a replica using python/arcpy and the tables which are being replicated are empty, only the schema is replicated. Is it possible to replicate also all the data in the tables using arcpy?

Re: Create Replica using arcpy

JakeSkinner — Fri, 14 Oct 2016 13:32:37 GMT

Hi Asterios,

With the CreateReplica_management function, the default for the expand_feature_classes_and_tables parameter for feature classes is to replicate all features; the default for tables is to replicate the schema only. You will want to set this parameter to ALL_ROWS to replicate the table rows.

Re: Create Replica using arcpy

KipoKipo — Thu, 27 Jul 2017 16:12:56 GMT

I tried ALL_ROWS and the replicated table still remained empty. Is there any update on this issue?

I guess replicating table with records should be DEFAULT because that is normally what replication does. From the project automation point of view it is much easier if this can be done by Arcpy.

Thanks!

Re: Create Replica using arcpy

AlexanderBrown5 — Fri, 28 Jul 2017 13:30:53 GMT

Kipo,

Can you post your exact code snippet?

~Alex

Re: Create Replica using arcpy

KipoKipo — Fri, 28 Jul 2017 15:05:19 GMT

The GP tool ran through and the snippet is as follows, but the table is still empty. Only with the Distributed Geodatabase toolbar did the table replica run through with complete records, based on my experience.

arcpy.CreateReplica_management(in_data="c:/Work/sqlcon/sqlwork.sde/sqlwork.DBO.ACIT", in_type="ONE_WAY_REPLICA", out_geodatabase="c:/Work/sqlcon/ser2work.sde", out_name="TabRep", access_type="FULL", initial_data_sender="PARENT_DATA_SENDER", expand_feature_classes_and_tables="ALL_ROWS", reuse_schema="DO_NOT_REUSE", get_related_data="GET_RELATED", geometry_features="", archiving="DO_NOT_USE_ARCHIVING")

Thanks!

Re: Create Replica using arcpy

AlexanderBrown5 — Sun, 12 Dec 2021 08:03:44 GMT

Kipo,

Instead of using the C path, try to utilize your direct database connection to your sqlwork.sde

For example my original SQL geodatabase is Enterprise_SDE

Replicated database is Replicated_SDE

Feature Class is "python_precision"

Here is the path to the origin feature class using the database connection path:

Database Connections\Enterprise_SDE.sde\Enterprise.SDE.python_precision‍‍‍‍‍‍‍‍

I was able to get the code below to work just fine utilizing the actual database connection paths.

import arcpy
arcpy.CreateReplica_management(in_data="Database Connections\Enterprise_SDE.sde\Enterprise.SDE.python_precision", in_type="ONE_WAY_REPLICA", out_geodatabase="Database Connections\Replicated_SDE.sde", out_name="TabRep", access_type="FULL", initial_data_sender="PARENT_DATA_SENDER", expand_feature_classes_and_tables="ALL_ROWS", reuse_schema="DO_NOT_REUSE", get_related_data="GET_RELATED", geometry_features="", archiving="DO_NOT_USE_ARCHIVING")‍‍‍‍‍‍

Try that and let me know if that works!

~Alex

Re: Create Replica using arcpy

KipoKipo — Fri, 28 Jul 2017 20:23:28 GMT

Hi Alex,

I still have no luck with this featureTable replication. The replicated table has only schema.

import arcpy
arcpy.CreateReplica_management(in_data="Database Connections/sqlwork.sde/sqlwork.DBO.ACIT", in_type="ONE_WAY_REPLICA", out_geodatabase="Database Connections/ser2work.sde", out_name="TabRep", access_type="FULL", initial_data_sender="PARENT_DATA_SENDER", expand_feature_classes_and_tables="ALL_ROWS", reuse_schema="DO_NOT_REUSE", get_related_data="GET_RELATED", geometry_features="", archiving="DO_NOT_USE_ARCHIVING")

Thanks!

Re: Create Replica using arcpy

AlexanderBrown5 — Mon, 31 Jul 2017 15:41:25 GMT

Hi Kipo,

I am sorry that is still not working for you. What version of ArcGIS are you utilizing for:

1. Desktop

2. SDE

Also, what version of SQL Server?

~Alex

Re: Create Replica using arcpy

KipoKipo — Mon, 31 Jul 2017 17:10:47 GMT

Hi Alex,

I'm using 10.5 and Sql Express 2014. Comparing your snippet with mine I

suspect that the express version might be the issue?

Re: Create Replica using arcpy

DarylHochhalter — Fri, 01 Jun 2018 14:46:08 GMT

I am currently having the very same issue using model builder and ArcGIS 10.4 advanced.

Re: Create Replica using arcpy

JoePlattner — Wed, 26 Sep 2018 16:00:16 GMT

I had issues with this in 10.3.1 and gave up trying to use python or model builder and just did it using ArcMap.

We have upgraded to 10.5.1 recently and I'm taking a look to see if this was fixed or easier in the new version. I found this in the tool help for the "Create Replica" tool. I haven't tried it yet, but it seems promising.

Create Replica (Data Management)

For tables the default filter is Schema Only; only the schema for the table will be replicated. To apply a filter to a table you must first create a table view setting desired filters. You can then use this as input into the Create Replica tool. See the Make Table View for more information. For more information on filters and replication see Preparing data for replication.