<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Using CreateReplica GP tool to check out tables in Python Questions</title>
    <link>https://community.esri.com/t5/python-questions/using-createreplica-gp-tool-to-check-out-tables/m-p/198448#M15241</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;I have also posted this question in the Geoprocessing forum.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;------------------------------------------------------------&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Here is the python code I am using for the CreateReplica geoprocessing tool:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN style="font-family:Courier New;"&gt;arcpy.CreateReplica_management("'Database Connections\\MySDEConnection.sde\\DB.OWNER.Table1';'Database Connections\\MySDEConnection.sde\\DB.OWNER.Table2'", "CHECK_OUT", "C:\Temp\MyFileGDB.gdb", "MyCheckoutVersion", "FULL", "CHILD_DATA_SENDER", "ALL_ROWS", "DO_NOT_REUSE", "GET_RELATED", "", "DO_NOT_USE_ARCHIVING")&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I changed the name of the connection and of the table names to make them generic for this example.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;What I am trying to do is to check out all rows for both feature classes and tables. &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;In the help for the CreateReplica tool, the name of the parameter that is giving me problems is called "expand_feature_classes_and_tables". The "ALL_ROWS" option that I am using for this parameter is supposed to check out all rows for both feature classes and tables.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;What is actually happening is that it only checks out the schema for the tables -- no data/no records. I would think that ALL_ROWS should be the default, but it isn't. The default option for this parameter is "USE_DEFAULTS" which only checks out all rows for feature classes. Check the help for the CreateReplica tool and see for yourself.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Any suggestions will be greatly appreciated.&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Thu, 30 Aug 2012 13:21:53 GMT</pubDate>
    <dc:creator>TimTeaford</dc:creator>
    <dc:date>2012-08-30T13:21:53Z</dc:date>
    <item>
      <title>Using CreateReplica GP tool to check out tables</title>
      <link>https://community.esri.com/t5/python-questions/using-createreplica-gp-tool-to-check-out-tables/m-p/198448#M15241</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;SPAN&gt;I have also posted this question in the Geoprocessing forum.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;------------------------------------------------------------&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Here is the python code I am using for the CreateReplica geoprocessing tool:&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN style="font-family:Courier New;"&gt;arcpy.CreateReplica_management("'Database Connections\\MySDEConnection.sde\\DB.OWNER.Table1';'Database Connections\\MySDEConnection.sde\\DB.OWNER.Table2'", "CHECK_OUT", "C:\Temp\MyFileGDB.gdb", "MyCheckoutVersion", "FULL", "CHILD_DATA_SENDER", "ALL_ROWS", "DO_NOT_REUSE", "GET_RELATED", "", "DO_NOT_USE_ARCHIVING")&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;I changed the name of the connection and of the table names to make them generic for this example.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;What I am trying to do is to check out all rows for both feature classes and tables. &lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;In the help for the CreateReplica tool, the name of the parameter that is giving me problems is called "expand_feature_classes_and_tables". The "ALL_ROWS" option that I am using for this parameter is supposed to check out all rows for both feature classes and tables.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;What is actually happening is that it only checks out the schema for the tables -- no data/no records. I would think that ALL_ROWS should be the default, but it isn't. The default option for this parameter is "USE_DEFAULTS" which only checks out all rows for feature classes. Check the help for the CreateReplica tool and see for yourself.&lt;/SPAN&gt;&lt;BR /&gt;&lt;BR /&gt;&lt;SPAN&gt;Any suggestions will be greatly appreciated.&lt;/SPAN&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 30 Aug 2012 13:21:53 GMT</pubDate>
      <guid>https://community.esri.com/t5/python-questions/using-createreplica-gp-tool-to-check-out-tables/m-p/198448#M15241</guid>
      <dc:creator>TimTeaford</dc:creator>
      <dc:date>2012-08-30T13:21:53Z</dc:date>
    </item>
  </channel>
</rss>

