2

I am attaching dozens of database files to a SQL Server instance and then I have to run sdesetup command to update the geodatabase license by pointing to my ArcGIS Server license. I am trying to find a way to automate this process.

Two ways to update the license (as to my knowledge are):

1.Connect to geodatabase instance as administrator user in ArcGIS Desktop (ArcMap for instance) and then use the Update ArcGIS Server License window to browse to the .ecp file or keycodes file.

enter image description here

2.Use sdesetup –o update_key ArcSDE command line to update the license. These command line utilities are going to be deprecated soon, though.

enter image description here

Neither of these alternatives provide any way to automate the process. In the latest Esri blog post on this topic, there was no information on this apart from what I have outlined above. I have not found any related ideas on ArcGIS Ideas either.

Is there any other way I am not aware of? Do you know if Esri is going to provide tools for automating license update process?

2

You can also backdoor it with a SQL script. The license string is stored in the SDE_SERVER_CONFIG table (SQL Server) or SERVER_CONFIG (Oracle) take a look in one of your existing licensed geodatabases using your SQL tool for the "AUTH_KEY" property and write an update statement that updates this record in the SERVER_CONFIG table in your other geodatabases. There is nothing illegal about doing this if the string you copied is from a geodatabase in the same instance (or even a different instance on the same physical site). You are just doing exactly what the "sdesetup -o update_key ..." command is doing.

1

At 10.1 They added a tool box for Managing the Geodatabase. One of these tools is 'Create Enterprise Geodatabase'. Once you have your basic database up and running, you use this tool to get your license from your ArcGIS Server and then create all of the underlying SDE geodatabase tables.

See: http://resources.arcgis.com/en/help/main/10.1/index.html#//001700000162000000

I just finished migrating our two large enterprise databases to a new server and created two new databases using this. I had a python script take care of this for all 4 databases. It is a lot easier than the old methods and having to run the old ArcSDE Post Install.

1

There currently is an enhancement for this functionality to be introduced to automate the process of updating the license file within the geodatabase prior to expiration:

Esri's enhancement ID: ENH-000083167 - Add functionality to warn and update an enterprise geodatabase license before expiration

  • Melissa, great, thank you. Do you know how one can search for enhancements on the Esri support web site? – Alex Tereshenkov Apr 22 '15 at 17:13

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.