You can try to edit them using Python. To edit an .sde file without using ArcGIS Pro, you can use Python scripting along with ArcPy, which is a Python site package that provides a useful and productive way to perform geographic data analysis, data conversion, data management, and map automation with Python.
import arcpy
# Define the connection parameters
connection_properties = {
"DATABASE": "your_database_name",
"USER": "your_username",
"PASSWORD": "your_password",
"SERVER": "your_server_name",
"INSTANCE": "sde:oracle11g:your_server_name", # Adjust the instance string for Oracle
"VERSION": "SDE.DEFAULT"
}
# Create a .sde connection file
sde_file = arcpy.CreateDatabaseConnection_management(
out_folder_path="C:/path/to/save", # Specify the folder path where you want to save the .sde file
out_name="my_connection.sde", # Specify the name for the .sde file
database_platform="ORACLE", # Change this to ORACLE
instance=connection_properties["INSTANCE"],
account_authentication="DATABASE_AUTH",
username=connection_properties["USER"],
password=connection_properties["PASSWORD"],
save_user_pass="SAVE_USERNAME",
database=connection_properties["DATABASE"],
version_type="TRANSACTIONAL",
version=connection_properties["VERSION"]
)
print(f".sde file created at: {sde_file}")
