You can reset developer license with initializing. In initialize process all data deleted. You can install temp license without initialize. Use license.bat/license.sh for generating temp license. You can find this script at bin/platform. You need to create temp license by db. We have these options:
CPS_MYS = mysql
CPS_HDB = hana
CPS_ORA = oracle
CPS_MSS = mssql
CPS_POS = postgres
CPS_SQL = ?
For example we create temp license for mysql: ./license.sh -temp CPS_MYS
You will get temp license for 90 day.
You need remove old license after 90 day for new one. You can delete it with below command: ./license.sh -delete SystemID HardwareKey SoftwareProducts
You can get above parameters with below command: ./license.sh -get
— thanks to Yusuf for above information.
Also you can reset trial license with updating user creation time.
UPDATE users set createdTS = NOW()
NOTE: NOW() command for MySql, you must chose relevant command for your database. There is no option running update command on UI, you can develop groovy script for running this command over jdbc.
Change all table priority for unload in short time.
create procedure update_unload_priority() LANGUAGE SQLSCRIPT AS
FOR SELECT 'ALTER TABLE "' || TABLE_NAME || '" UNLOAD PRIORITY 9;' AS SQLTEXT
WHERE SCHEMA_NAME = 'MYSCHEMA' AND TABLE_TYPE = 'COLUMN' and temporary_table_type = 'NONE' AND unload_priority <> 9;
FOR cur_row AS C_TABLE DO