Erik Cole Acclaimed Contributor.
Acclaimed Contributor.
256 views

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?

Labels (1)
0 Likes
3 Replies
Super Contributor.. JodieOndrejka Super Contributor..
Super Contributor..

Re: refreshing dev databases from 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.

0 Likes
Outstanding Contributor.. Loc_Nguyen_PPM Outstanding Contributor..
Outstanding Contributor..

Re: refreshing dev databases from prod

Hi Eric,

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.

Regards,

“HP Support
If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.”
0 Likes
Outstanding Contributor.. Amishra Outstanding Contributor..
Outstanding Contributor..

Re: refreshing dev databases from prod

Hi Eric,

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!

Cheers,

Ajay

Regards,
Ajay Mishra
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.