Create or refresh a test environment

[p.behr]

I want to use my production instance to either create a new test environment or completely refresh an existing environment (on a different partition).
I can save, export, import all the apps individually, but seems it might be faster and safer to accomplish the refresh by restoring the database tables.
Perhaps we only want a subset of the tables (we might not want all the same users, we might not care about error log, etc.).

Any thoughts/ideas?
How do you guys quickly spin up a test environment?

Thanks in advance :-)

[robert.swanson]

If you just want to copy over all the NAB objects, and you don't mind replacing anything that already exists in the test instance, you could simply copy over all the NAB-related files:

VVDTA100
VVDTA200
VVDTA210
VVDTA220
VVDTA300
VVDTA400
VVDTA500
VVDTA600
VVDTA900
VVDTA905
VVWDG100
VVWDG200
VVWDG300
VVWDG310
VVQRY200
VVQRY300
VVQRY500
VVQRY600
VVAPPS*

*For VVAPPS, only copy over records where VVISNABAPP='1'

[p.behr]

Ran into a couple of issues with FK constraints in VVAPPS: needed to also handle VVAPPGRPS and VVGROUPS.
Other than that I think it worked (initially it looks good ... needs more thorough testing).
And now I can refresh the environment in about 1.047 seconds (give or take a .01) :cool:

[p.behr]

Just ran into another FK issue with VVUSRAPPS (prevents delete of VVAPPS).

[robert.swanson]

That file is for holding user autostart and favorite apps. It would probably be a good idea to simply clear that file out on the destination instance prior to bringing over any VVAPPS records.