Issues writing to SQL Server from ArcGIS Pro

719
2
Jump to solution
06-23-2021 12:58 AM
Labels (3)
DeanHowell1
Occasional Contributor III

I am trying to write a new dataset to SQL Server via ArcGIS Pro using the import tool in Catalog.

The following is the process I am using.

1. Load new layer (shapefiles) into ArcGIS pro

2. Open Catelog and connect to SQL Database

3. Right click on database and select import

4. Add layer that is in map and enter new name and run

I get the following displayed

DeanHowell1_0-1624434795097.png

I have read access to the database and can do simple changes like rename a table in SQL Server Management Studio but can write a new layer.

What permissions are I missing?

 

 

 

Tags (1)
0 Kudos
1 Solution

Accepted Solutions
JayantaPoddar
MVP Esteemed Contributor

What is the license level of ArcGIS Pro? You can't edit/write on Ent. Geodatabase using a Basic License of ArcGIS Desktop.

Some other related issues Error: Error creating this geodatabase. This application is not licensed to perform this operation 



Think Location

View solution in original post

2 Replies
JayantaPoddar
MVP Esteemed Contributor

What is the license level of ArcGIS Pro? You can't edit/write on Ent. Geodatabase using a Basic License of ArcGIS Desktop.

Some other related issues Error: Error creating this geodatabase. This application is not licensed to perform this operation 



Think Location
DeanHowell1
Occasional Contributor III

Thanks that was the issue and the layer can now be seen in SQL Server by ArcGIS but not by anything else, so might need to look deeper.

0 Kudos