The table I am trying to recreate has these properties
Data Type File Geodatabase Feature Class Feature Type Simple Geometry Type Polygon <<<< WHAT I WANT TO RECREATE
My target SQL table is this:
CREATE TABLE [dbo].[MyAggregateTable]( [OBJECTID] [int] IDENTITY(1,1) NOT NULL, [SHAPE] [geometry] NULL, [Status] [nvarchar](25) NULL, ...
And the resulting properties are:
Data Type Enterprise Database Feature Class Feature Type Simple Geometry type Any <<<< NOT THE SAME!
FURTHER PROGRESS / EDIT
Now I have discovered that I can manipulate the geometry type by using the ArcCatalog App. I can change the Type to "Polygon Features" manually on the FeatureClass properties - but it's not permanent. As soon as I exit, it 'forgets'.
Then I dicovered that if I manually "Load Data" in the ArcCatalog App, the FeatureClass properties are set, the data is loaded, and we are good to go.
However, if I flush the table, (not DROP), the geometry type reverts back.
So basically a SearchCursor / InsertCursor approach does not work >>> it has to be done manually.