SQL database (Non Spatial) name changed to include a dash(-), now I cannot work with it using python.

Question

My agency recently migrated to the Microsoft Azure Cloud (sql server) and with it came a database name change. The name of the new database is "Migrate-Forestry".  I've gone through and updated my sde connection file and made sure my python scripts are pointing to it correctly. However all of them are now failing when trying reach a table through the sde connection. It's the generic error "Table does not exist or is not supported." I've done a lot of research but cannot find a solid answer to why my scripts are failing. I think it's because my database name has a dash in it, but just wanted clarification on this. Any help would be appreciated.

Thanks,

Michael

MichaelTorbett · Answer

Yes, the hyphens seemed to be the problem. My db admin ended up renaming the database without a hyphen and that solved my issues.

AndrewRitchie_CoL · Answer

Hi Michael,

Wondering what the resolution was in your case?

A few months back I was trying to connect on prem ArcGIS Pro, to a non-spatial AzureSQL database (with recommended Microsoft naming, which includes hyphens). I was able to make the connection, browse the list of tables, but unable to add the tables to the map, or browse the data.

We are about to pull the trigger on renaming the server/database because of this.

Today when I decided to test it again, I am now able to add tables to the map, and can browse data for smaller tables. I cannot view data for larger tables, so my issue now may be a timeout, rather than anything to do with the naming. In the interim - we have bumped up the AzureSQL server resources - so that may also have been part of my issue.

Were the hyphens ever the problem?

MichaelTorbett · Answer

Thanks George! I have created a case with ESRI Support. Maybe  there's workaround using python or something else.