nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

arcpy to edit *.sde files

MichaelKnapp

Hi there -

Is it possible to, using arcpy, to edit the content of an *.sde connection file (or files) directly?

Based on some initial research, it seems this is not possible and that the closest I might be able to get would be to use CreateArcSDEConnectionFile_management to generate multiple new files at once.

Thanks.

Find more posts tagged with

Accepted answers

NeilAyres

Once you have the original, you can make a connection to it.

env.workspace = "path and name of connection file . sde"

Then you can recover the properties of that connection file using Describe.

All comments

MichaelKnapp

Great, thanks again for all the information.

NeilAyres

Once you have the original, you can make a connection to it.

env.workspace = "path and name of connection file . sde"

Then you can recover the properties of that connection file using Describe.

MichaelKnapp

All that's needed is to swap out the server domain name in the *.sde files, but there are lots of *.sde files to update.

What would be the best arcpy function to use to read properties of the existing *.sde files?

Thanks so much for your quick reply.

NeilAyres

What are your requirements to edit a connection file?

I think you are correct, you could read a connection file, create a new one, then overwrite the original.

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.