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
Method 1
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.
Method 2
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.