topic Re: Using CreateReplica GP tool to check out tables in Geoprocessing Questions https://community.esri.com/t5/geoprocessing-questions/using-createreplica-gp-tool-to-check-out-tables/m-p/417115#M14091 <HTML><HEAD></HEAD><BODY><SPAN>Here is the python code I am using for the CreateReplica geoprocessing tool:</SPAN><BR /><BR /><SPAN style="font-family:Courier New;">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")</SPAN><BR /><BR /><SPAN>I changed the name of the connection and of the table names to make them generic for this example.</SPAN><BR /><BR /><SPAN>As I said in my first post, the parameter that I have set to "ALL_ROWS" is supposed to check out all rows for both feature classes and tables.&nbsp; What is happening for me is that it only checks out the schema for the tables -- no data/no records.&nbsp; I would think that ALL_ROWS should be the default, but it isn't.&nbsp; 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.</SPAN><BR /><BR /><SPAN>I hope this helps you get a better idea of what I am trying to do.</SPAN><BR /><BR /><SPAN>Any suggestions will be greatly appreciated.</SPAN></BODY></HTML> Thu, 30 Aug 2012 13:01:14 GMT TimTeaford 2012-08-30T13:01:14Z Using CreateReplica GP tool to check out tables https://community.esri.com/t5/geoprocessing-questions/using-createreplica-gp-tool-to-check-out-tables/m-p/417114#M14090 <HTML><HEAD></HEAD><BODY><SPAN>I am trying to use the CreateReplica geoprocessing tool to check out tables using a "</SPAN><STRONG>CHECK_OUT</STRONG><SPAN>" type of replica.&nbsp; The problem I am having is that my tables get checked out with only their schema -- no data/no records.</SPAN><BR /><BR /><SPAN>I see in the help that there is a parameter called "</SPAN><STRONG>expand_feature_classes_and_tables</STRONG><SPAN>". I first tried using the "</SPAN><STRONG>USE_DEFAULTS</STRONG><SPAN>" option and the tables would check with just their schema -- no data/no records.&nbsp; I then tried using the "</SPAN><STRONG>ALL_ROWS</STRONG><SPAN>" option and the tables STILL checked out with just their schema -- no data/no records.</SPAN><BR /><BR /><SPAN>I want the tables to check out with all of their data.&nbsp; Does anyone have any suggestions on how I can do this?</SPAN></BODY></HTML> Wed, 29 Aug 2012 19:48:40 GMT https://community.esri.com/t5/geoprocessing-questions/using-createreplica-gp-tool-to-check-out-tables/m-p/417114#M14090 TimTeaford 2012-08-29T19:48:40Z Re: Using CreateReplica GP tool to check out tables https://community.esri.com/t5/geoprocessing-questions/using-createreplica-gp-tool-to-check-out-tables/m-p/417115#M14091 <HTML><HEAD></HEAD><BODY><SPAN>Here is the python code I am using for the CreateReplica geoprocessing tool:</SPAN><BR /><BR /><SPAN style="font-family:Courier New;">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")</SPAN><BR /><BR /><SPAN>I changed the name of the connection and of the table names to make them generic for this example.</SPAN><BR /><BR /><SPAN>As I said in my first post, the parameter that I have set to "ALL_ROWS" is supposed to check out all rows for both feature classes and tables.&nbsp; What is happening for me is that it only checks out the schema for the tables -- no data/no records.&nbsp; I would think that ALL_ROWS should be the default, but it isn't.&nbsp; 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.</SPAN><BR /><BR /><SPAN>I hope this helps you get a better idea of what I am trying to do.</SPAN><BR /><BR /><SPAN>Any suggestions will be greatly appreciated.</SPAN></BODY></HTML> Thu, 30 Aug 2012 13:01:14 GMT https://community.esri.com/t5/geoprocessing-questions/using-createreplica-gp-tool-to-check-out-tables/m-p/417115#M14091 TimTeaford 2012-08-30T13:01:14Z