arcgis 数据库授权更新

最新推荐文章于 2025-01-03 15:26:01 发布

原创最新推荐文章于 2025-01-03 15:26:01 发布 · 522 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #sqlserver #sql

ArcGIS 专栏收录该内容

9 篇文章

订阅专栏

这篇博客介绍了如何使用ArcGIS Desktop工具箱和SQL语句来更新ArcGISServer和Oracle、SQL Server的许可配置。步骤包括从许可文件中复制特定行并更新相应的数据库配置。

pg

通过arcgis desktop工具箱

oracle(只能通过sql语句)

先从ArcGIS Server的许可文件(*.ecp)中找到以arcsdeserver打头的一行，并将其拷贝下来

update server_config set char_prop_value='arcsdeserver,108,ecpXXXXXXXXXX,xx-jan-20xx,XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX'
where prop_name='AUTH_KEY';
commit;

sqlserver(只能通过sql语句)

先从ArcGIS Server的许可文件(*.ecp)中找到以arcsdeserver打头的一行，并将其拷贝下来

update sde_server_config set char_prop_value= 'arcsdeserver,108,ecpXXXXXXXXXX,xx-jan-20xx,XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX' 
where char_prop_value='AUTH_KEY'";