topic Re: arcpy to edit *.sde files in Python Questions

arcpy to edit *.sde files

MichaelKnapp — Mon, 16 May 2016 17:58:58 GMT

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.

Re: arcpy to edit *.sde files

NeilAyres — Mon, 16 May 2016 18:06:06 GMT

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.

Re: arcpy to edit *.sde files

MichaelKnapp — Mon, 16 May 2016 18:11:48 GMT

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.

Re: arcpy to edit *.sde files

NeilAyres — Mon, 16 May 2016 18:21:51 GMT

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.

Re: arcpy to edit *.sde files

MichaelKnapp — Mon, 16 May 2016 18:46:52 GMT

Great, thanks again for all the information.

Re: arcpy to edit *.sde files

RebeccaStrauch__GISP — Mon, 16 May 2016 19:42:25 GMT

Hi Mike,

Kim at dec was asking the same question via email to me. Haven't made contact yet. Is thus related? I mentioned you just asked the question here.

just FYI, for finding and updating other broken link, I had an addin Python addin for data inventory and “broken-link” repair. Not 100%, and haven't had time to keep working on it, but may help fix other issues in the future.