I try use arcpy.JoinField_management(inFeatures, inField, joinTable, joinField, fieldList) to join SQL server database tables to shapefiles directly, using an ArcSDE connection. The database connection from ArcMap is successful.
Following the tip from How to run “sdetable register” command in SQL Server? at How to run "sdetable register" command in SQL Server?
I ran the command:
sdetable -o register -t {table} -c {column} -C {database}
on the desktop that ArcGIS 10.3.1 is installed.
However, it gives error message:
'sdetable' is not recognized as an internal or external command..
I searched "sdetable" in the desktop and didn't find some file. There are a lot of sde*** in the ArcGIS folder, but no "sdetable".
If "sdetable" command is not available for 10.3.1, is there other alternative option to join the tables? I don't prefer to export database tables to csv from the SQL Server, then import each one into ArcGIS to make it have ObjectID.