0

I am able to import a table created in SQL Server into ArcMap by using database connection.

Can I also do a reverse process i.e. upload an ArcMap table back into SQL Server. I am using ArcMap version of 10.6.1?

4
  • 1
    Did you try to do it ? if yes what did you try and what didn't work ?
    – J.R
    Oct 4 '21 at 15:33
  • 2
    While ArcGIS can load table data into PostgreSQL without an Enterprise geodatabase, the other RDBMSes require an Enterprise geodatabase installed and licensed within the database to utilize tools like FeatureClassToFeatureClass or FeatureClassToGeodatabase to copy data. I've written Python code to export layers as SQL statements (CREATE TABLE, INSERT..., CREATE INDEX ...) to both SQL Server and PostgreSQL, using arcpy.ArcSDESQLExecute(), so it is possible, even if not an EGDB. Please Edit the question to specify whether an Enterprise geodatabase is present and what you have tried.
    – Vince
    Oct 4 '21 at 18:42
  • I have not tried anything yet. I am a new user to ArcGIS. I used to work in Mapinfo and now shifted to ArcGIS. In Mapinfo it was easier to load/import table from SQL using DBMS connection. Similarly it was also easy to export table to SQL server using inbuilt Mapinfo tool called "Easyloader". I was wondering that if ArcGIS provide similar type of toll to export table to SQL server.
    – Riz
    Oct 5 '21 at 9:49
  • Beside I have both licensed ArcMap 10.6.1 and ArcGIS Pro. I can google meanwhile how arcpy.ArcSDESQLExecute() command works.
    – Riz
    Oct 5 '21 at 9:52

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.