1

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.

Improve this question
  • 1
    Please edit your question to specify which release of ArcGIS you are using. The command-line utilities were deprecated at ArcGIS 10.2 and are no longer available at ArcGIS 10.3. At 10.2 and before you would need to install the application server or administration tools binarie before that utility would be available. – Vince Dec 15 '15 at 17:26
  • The ArcGIS I am using is 10.3.1. so the command-line utilities is not available. what other alternatives I can use to solve this problem. Thanks – Jen Dec 15 '15 at 17:51
  • Please edit the question with more details about why you're looking to register a table. Some don't need to be registered, some can be registered by Desktop or ArcPy, and some use cases require using the deprecated tools from a 10.2.2 install. While you're at it, please include the 10.3.1 use in the question – Vince Dec 15 '15 at 17:59
  • I just edited the question. when I use arcpy to join the tables, it gives me error message: ExecuteError: ERROR 000339: Input Database Connections\Connection to ****.sde*.dbo.* does not have OIDs Failed to execute (JoinField). – Jen Dec 15 '15 at 18:01
  • I don't recommend straddling ASCII, shapefile and geodatabase. If ArcGIS creates the table, it will have been registered, so 'sdetable' use would be moot. – Vince Dec 15 '15 at 18:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.