Script to load multiple features into already existing feature class?

Question

I have an existing feature class in a file gdb.  I am trying to write a python script to load data from a SQL2012 gdb.  I am new to this.  Normally, I would just drop a tool into modelbuilder and convert it to a python script.  However, I do not know how to do this with the Simple data loader that I use in ArcCatalog.  I would think that someone has already done this.  Any help is appreciated.

DarrenWiens2 · Answer

^ their entire use is quite different.

IanMurray · Answer

Note the parameter order changes slightly between da Cursors and standard Cursors

DarrenWiens2 · Answer

You can improve performance by using the cursors in the data access module‌. So, arcpy.da.SearchCursor rather than arcpy.SearchCursor, and arcpy.da.InsertCursor rather than arcpy.InsertCursor.