Arcmap更新sde库许可

概述

    一般来说SDE的试用许可我会建议用户在没有到期之前进行续期，也就是更新许可。否则的话，如果SDE试用许可到期了，除了PostgresSQL数据库之外，我们只能通过SQL语句的方式来进行更新。在到期之前我们可以通过【更新企业级地理数据库许可】工具进行操作：

    

 

 

过期了，只能通过SQL进行许可的更新操作。这是由于SDE的许可信息是存储在SDE空间库里的server_config(根据数据库的不同表名可能有所不同，如SQLSerer的表名为sde_server_config)表中一行中，可以通过

    select * from server_config

来查看SDE许可的信息。

    在更新许可之前，需要先从ArcGIS Server的许可文件(*.ecp)中找到以arcsdeserver打头的一行，并将其拷贝下来，格式类似：

    arcsdeserver,101,ecp573151040,29-jul-2016,B5FAJH5HTET0M338A218,72A6888B41EB268B1ADE0D0B626B20BC5E9ACBC0D8750985297C858F208A6299D24D6220F9FE626312A194576EA3194F040E1B9021DFC303AEF2F3BA49B2AA5238EE65235570F7CAA90307FC6EF0730ACB78CE89AB66C307F88DD0F449D7511DC05A181A366BF1A8043E614BBC899DA47B577A7943EA85BA18AC6C93092B7B07,FID_5995f8f5_1471168fb83_19c4

oracle

update server_config set char_prop_value= 'arcsdeserver,101,ecp573151040,29-jul-2016,B5FAJH5HTET0M338A218,72A6888B41EB268B1ADE0D0B626B20BC5E9ACBC0D8750985297C858F208A6299D24D6220F9FE626312A194576EA3194F040E1B9021DFC303AEF2F3BA49B2AA5238EE65235570F7CAA90307FC6EF0730ACB78CE89AB66C307F88DD0F449D7511DC05A181A366BF1A8043E614BBC899DA47B577A7943EA85BA18AC6C93092B7B07,FID_5995f8f5_1471168fb83_19c4'

where prop_name='AUTH_KEY';

commit; 

DB2

update server_config set char_prop_value=' arcsdeserver,101,ecp573151040,29-jul-2016,B5FAJH5HTET0M338A218,72A6888B41EB268B1ADE0D0B626B20BC5E9ACBC0D8750985297C858F208A6299D24D6220F9FE626312A194576EA3194F040E1B9021DFC303AEF2F3BA49B2AA5238EE65235570F7CAA90307FC6EF0730ACB78CE89AB66C307F88DD0F449D7511DC05A181A366BF1A8043E614BBC899DA47B577A7943EA85BA18AC6C93092B7B07,FID_5995f8f5_1471168fb83_19c4' where char_prop_value='AUTH_KEY'"

SQL Server

update sde_server_config set char_prop_value=' arcsdeserver,101,ecp573151040,29-jul-2016,B5FAJH5HTET0M338A218,72A6888B41EB268B1ADE0D0B626B20BC5E9ACBC0D8750985297C858F208A6299D24D6220F9FE626312A194576EA3194F040E1B9021DFC303AEF2F3BA49B2AA5238EE65235570F7CAA90307FC6EF0730ACB78CE89AB66C307F88DD0F449D7511DC05A181A366BF1A8043E614BBC899DA47B577A7943EA85BA18AC6C93092B7B07,FID_5995f8f5_1471168fb83_19c4' where char_prop_value='AUTH_KEY'"