topic Re: Issues writing to SQL Server from ArcGIS Pro in Data Management Questions

Issues writing to SQL Server from ArcGIS Pro

DeanHowell1 — Wed, 23 Jun 2021 07:58:06 GMT

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

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?

JayantaPoddar — Wed, 23 Jun 2021 08:35:09 GMT

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

DeanHowell1 — Wed, 23 Jun 2021 23:18:22 GMT

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.