I have a table in a SQL2019 database that contains X, Y coordinate information and various attributes. Work is being done in ArcGIS Pro 2.7.3
Right-click is used to Export -> Table to Point Feature Class is executed from the Database connection, the resulting feature class does not have all of the fields in the original Table.
Table is added to map from the database connection and then XY Table to Point is run from the geoprocessing pane, the resulting feature class has all of the expected fields.
Any idea why these results are not the same? Happy to provide more information if told what could be useful.
What are the field names that are being dropped? Reserved names? or do they have no apparent pattern?
Your second option, of not using the shortcut but the tool is the way to go. It appears from the script
"C:\... Your_Install_Folder ...\Resources\ArcToolBox\Scripts\XYTableToPoint.py"
That it use cursors to complete the work, so I would expect a better handling of dates and times. There are lots of threads on the web about how to handle datetime and csv outputs, many are language specific and many suggest converting to text fields first. I would skip doing workarounds and let the arctoolbox tools/scripts handle the work