refreshing dev databases from prod
Now that the licensing is done through the database instead of on the app server side, what is the best practice for refreshing dev & test databases from a copy of prod?
We have a script we run to refresh all our non-PROD environments. This is the command that is in our script to reset the licenses: ./kLicenseInstall.sh [ENV="[REQ.VP.DEST_PPM]".UD.PPM_SERVER_NAME].dat
[REQ.VP.DEST_PPM] is the field on our refresh form that allows us to pick which non-PROD environment we are refreshing.
Hope that helps.
As the license since 9.3.x store lincense in DB, you can refresh file system and db dump from Production to Non-Production then re-run the lincense used for Non-Production again, that will be fine.
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”
We do refresh data quite often at our client end. Once we refresh the DB, we make sure to reapply the license for the non prod instance using sh kLicenseInstall command.
Thing to note is, that since the licenses are stored in DB, you may need to delete/update the old licenses in the KNTA_LICENSE_DATASOURCE table to make sure your license counts are proper. [Please take a backup of the table before doing that].
To delete simply use delete command to clear everything out.
to update use: UPDATE KNTA_LICENSE_DATASOURCE SET IS_DELETE = 1; basically you are setting the IS_DELETE column to 1 from 0.
Hope this helps!