I have a shapefile that I would like to save to a specific catalog database. I created a new database connection in arc catalog but I am not sure how to save this shapefile that was sent to me via email to my new catalog. Ultimately I want to export the database table with that shapefile data(attributes) to a separate SQL file.

  • 1
    You don't save shapefiles into databases. But you can export/copy the data from a shapefile into a feature class within a database. Is that what you're attempting to do? If so, please re-word your question to reflect this. Also, please provide more information about the kind of database you want to store the data in. Is in an enterprise geodatabase, or a file geodatabase (or other)? Again, please edit your question to include this information. – Son of a Beach Aug 21 '19 at 2:52
  • Well I was sent a shapefile which I can open, however I want to export the attributes from the shapefile, that is the attribute table, into a separate SQL Server database file that I can then import into a different SQL database. – kabuto178 Aug 21 '19 at 2:58
  • 1
    Are you saying that your database is NOT an ESRI geodatabase? Also, SQL databases are NOT files. When you say "SQL Server database file" do you really mean just "SQL database"? Because that is not a file. – Son of a Beach Aug 21 '19 at 3:04

If your destination is an ESRI geodatabase (enterprise geodatabase or file geodatabase).

Use the "Feature Class to Feature Class" tool, or the "Copy Features" tool.

For more information (including the difference between the two tools) see: Difference between Copy Features and Feature Class to Feature Class tools?

OR, if you only want the attributes, and not the spatial information, use the "Table to Table" tool.

If your destination is NOT an ESRI geodatabase, load up the shapefile in ArcMap, and right click on the layer in the table of contents, and then choose "Open Attribute Table". Then in the attribute table's menu (top-left icon), choose "Export".

You can export to text/CSV or to DBase format, either of which should be able to be imported into an SQL database using your favourite SQL tools.

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.